Hoe to change text format .126 to number format 0.126

  • Thread starter Thread starter vitality
  • Start date Start date
V

vitality

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
 
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.
 
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
 
unless the figures were originally entered as '.123 when the 'Value'
will be required.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to change text format .126 to number format 0.126 ? 2
How to tell number of spaces between values in saved text file fromthe original xls file 1
How to tell spaces between values in saved text file from theoriginal xls file 2
Output data to file in Fortran 6F10.3 format 2
Formula to change Phone Number format 6
Numbers SHOULD BE text 3
Format change of phone number 7
Formatting Text to Numbers for Dates 2

Back
Top