spotger.blogg.se

Select the cells and clear formating (Home tab > Editing > Clear -> 'Clear Formats'). We need to clear the hidden character which could have come as result of formatting.

So if you see left aligned numbers, that's a flag, excel thinks it's text. This can be noted as the cell values are left aligned as in text, excel automatically right align numbers. The problem was hidden characters in the data due to which excel sees the value as text. Excel automatically knows if the data is numeric. Even though it's all numbers, the Quick Analysis Tool I get is the same as if the cells were text fields (no math functions).Īnd this issue was not that the cell should have be numeric type, this operation works on general cell format. Professional versions are available for a fee.I got in this weird situation when I copied data from a table in PowerPoint. A limited non-commercial version of VNC Connect is free. The two computers don't need to be the same type so you can use VNC Connect to view a Windows desktop at the office from a Mac or Linux computer.