Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Hoe to change text format .126 to number format 0.126
Hi everyone. I has a column of data full of: .123 .123 .65 .89 -- all in text format. Is it possible to have some equation to change those data to: 0.123 0.123 0.65 0.89 -- as number format. Thx -- vitality ------------------------------------------------------------------------ vitality's Profile: http://www.excelforum.com/member.php...o&userid=27267 View this thread: http://www.excelforum.com/showthread...hreadid=473711 |
#2
|
|||
|
|||
Assuming that your data is in column A, in B1 put =value(A1) and formula-copy that for the length of your data, the format 0.123 is the General format, and so should suit your needs. Additionally, having done that, you can Copy column B and Paste Special, Values (back into column B) then delete column A. vitality Wrote: Hi everyone. I has a column of data full of: .123 .123 .65 .89 -- all in text format. Is it possible to have some equation to change those data to: 0.123 0.123 0.65 0.89 -- as number format. Thx -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=473711 |
#3
|
|||
|
|||
Changing the format does not change the underlying value. In
particular, you must do more than simply reformat to change text digits into a number. Copy an empty cell, select the column and Edit|Paste Special|Add. Jerry vitality wrote: Hi everyone. I has a column of data full of: .123 .123 .65 .89 -- all in text format. Is it possible to have some equation to change those data to: 0.123 0.123 0.65 0.89 -- as number format. Thx |
#4
|
|||
|
|||
unless the figures were originally entered as '.123 when the 'Value' will be required. Jerry W. Lewis Wrote: Changing the format does not change the underlying value. In particular, you must do more than simply reformat to change text digits into a number. Copy an empty cell, select the column and Edit|Paste Special|Add. Jerry vitality wrote: Hi everyone. I has a column of data full of: .123 .123 .65 .89 -- all in text format. Is it possible to have some equation to change those data to: 0.123 0.123 0.65 0.89 -- as number format. Thx -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=473711 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert numbers from text format to number format | Excel Discussion (Misc queries) | |||
How to change default cell format to "Text" | Excel Discussion (Misc queries) | |||
Change colour of Text if number in cell exceed limit | Excel Worksheet Functions | |||
Format Number to Text | Excel Worksheet Functions | |||
How do you change sort defaults for combined text number & hyphen. | Excel Discussion (Misc queries) |