Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Numbers act like text
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Numbers act like text
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 "Evan" wrote: 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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Numbers act like text
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 Evan wrote: 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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Numbers act like text
=VALUE(A1) might work Ken Johnson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text entries behaving like numbers | Excel Discussion (Misc queries) | |||
How can I use "VLOOKUP" with cells containing both Text & Numbers? | Excel Worksheet Functions | |||
Convert text numbers to numbers | Excel Worksheet Functions | |||
How to reformat numbers stored as text (apostrophe at beginning) | Excel Discussion (Misc queries) | |||
Converting Numbers to Text properly | Excel Discussion (Misc queries) |