Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Converting text to numbers
I've imported a csv file where everything as come through as text.
I want to convert the entries in some columns from text to numbers. I can do it individually by clicking on the warning icon (!) at the side of each cell and choosing the relevant option. But can SKS tell me how to do it for a range. TIA Rob |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Converting text to numbers
If the data is in columns, you can try Text to Columns, mapping the column
back onto itself. -- Gary''s Student - gsnu2007g "BRob" wrote: I've imported a csv file where everything as come through as text. I want to convert the entries in some columns from text to numbers. I can do it individually by clicking on the warning icon (!) at the side of each cell and choosing the relevant option. But can SKS tell me how to do it for a range. TIA Rob |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Converting text to numbers
try selecting all cells, press ctrl+C twice and click the paste icon.
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting numbers to text | Excel Discussion (Misc queries) | |||
Converting text to numbers | Excel Worksheet Functions | |||
Converting numbers formatted as text to numbers | Excel Discussion (Misc queries) | |||
about converting numbers to text. | Excel Discussion (Misc queries) | |||
converting numbers to text and prefill text field with 0's | Excel Discussion (Misc queries) |