Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

I have an excel file for average rainfall by month and I added that on ArcMap. while I tried to check the statistics the tool is passive for last 3 months and I checked the data on arcmap, they are aligned left instead of right. I can check the statistics for those which are right aligned but not for left aligned. Anybody can suggest me why they are left aligned. I did multiple times for this with different sheets for same data but the result is same. Thank you

share|improve this question

1 Answer 1

Left aligned in excel means that the values are stored as text instead of numbers. Try going back into excel and make sure the values are typed as numbers (e.g. 30.2 instead of 30.2in or 30.2"). If the numbers already look like numbers but are still left aligned, there should be an error message (normally a green triangle in the top left corner).

If that is the case, click in the cell and you get a warning diamond. Click on the warning diamond and select "Convert to Number" on the context menu.

I tried to generate a case of left aligned versus right aligned in ArcMap, but have not been able to do it. Is this an xls sheet or an xlsx sheet?

share|improve this answer
    
Thank you for your Answer Castillo. In excel, they are in right align but while they add in Arcmap, last few months will change in left align. –  user16377 Mar 20 '13 at 21:36
    
are there any blank rows? if so the field is assessed as text/string. alternately, format all columns explicitly as your desired number format –  Dan Patterson Mar 20 '13 at 23:19
    
So, in arcmap, three of them are left aligned but the rest are right aligned? What does ArcMap think the column type is? Maybe you should save the sheet as a csv and try from there. –  blord-castillo Mar 21 '13 at 13:45

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.