Formatting Numbers

[Peledon]

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.

 

[Jerry W. Lewis]

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]

Thank you, that worked perfect.

I am exporting from a database that was designed for our use, think designed
in Oracle though I can say for certain not being a whiz kid at these kind of
things.
Thanks again for your help.

 

[Jerry W. Lewis]

The way that Oracle is writing the file, causes Excel to interpret the data
as text. Your programmers may be able to revise the output file so that
Excel will interpret it as numbers. Otherwise continue to use this
work-around.

Jerry