Home |
Search |
Today's Posts |
#1
|
|||
|
|||
converting to numbers
When I import some data into excel and copy and past it I am asked whether i
want to convert the text into numbers (which I do!) via a pop-up "!" mark that hovers next to the data. The "text" that it asks me to convert is in fact already a number but obviously excel does not recognise it as so! Is there any function of excel that will allow me to convert my text into numbers straight away without waiting for a prompt? Help would be gratelfully appreciated!!! Thanks Steve |
#2
|
|||
|
|||
You can copy an empty cell. select the text numbers and do editpaste
special and select add -- Regards, Peo Sjoblom "smintey" wrote in message ... When I import some data into excel and copy and past it I am asked whether i want to convert the text into numbers (which I do!) via a pop-up "!" mark that hovers next to the data. The "text" that it asks me to convert is in fact already a number but obviously excel does not recognise it as so! Is there any function of excel that will allow me to convert my text into numbers straight away without waiting for a prompt? Help would be gratelfully appreciated!!! Thanks Steve |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting Numbers to Time | Excel Worksheet Functions | |||
Converting Numbers to Text properly | Excel Discussion (Misc queries) | |||
roundoff when converting text to numbers | Excel Worksheet Functions | |||
Converting negative numbers in a range of cells to zero | Excel Discussion (Misc queries) | |||
converting dates into numbers | Excel Discussion (Misc queries) |