Numbers act like text

E

Evan

We get spreadsheets from another application that have a column of "numbers"
that act like text. The only way to get them to act like numbers is to copy
them out to a text file and then copy them back in. Is there an easier way?
 
T

T Kirtley

Format the cells with a numeric format, goto a blank non-text cell and copy
it, then select the range of 'text numbers', select paste special from the
Edit menu and choose 'Add" That will convert the text to numeric values, and
wont affect any cells containing true text in the selected range.

HTH,

TK
 
P

Pete_UK

You could try this short-cut method - highlight the column with the
offending "numbers". Click Data | Text-to-columns and in the panel that
pops up just click Finish.

Hope this helps.

Pete
 
Top