Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |