How are you exporting the data to Excel, and from where?

Formatting does not change the value in a cell. In particular, it cannot
change text to a number--it merely prepares the cell to accept a number.

One possible workaround is to copy a blank cell, then select the range of
imported data and Edit|Paste Special|Add. Adding zero to each cell should
coerce their contents to numbers if it is possible to do so.

Jerry

"Peledon" wrote:

When I export data to excel it doesnt recognise the numbers as numbers. Even
when I format the row to numbers it doesn't recognise them. I have to retype
then in order for me to do calculations. Any help greatly appreciated.