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
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?