How 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.

Th
 
Lets say that the first text field is in cell A1 and they go down the
column B1, C1 and so on. I would use the column next to it to plug in
a formula. If there is no available column, insert one temporarily.
in cell A2 type =value(A1)
Just copy that formula down. You can change the formatting of the
cell but it should be a number now.

Sometimes this works. In cell A2 type =A1*1
Sometimes that will convert it to a number.
 
An alternate approach is given under your post in
microsoft.public.excel.misc. Please do not separately post the same
question to multiple newsgroups.

Jerry
 

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

Hoe to change text format .126 to number format 0.126 3
Conditional Formatting from a group 6
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
Number format to Text 4
HOW DO I CHANGE THE FORMAT OF A SS# FROM 123-45-6789 TO 123456789 4
Sort columns 8
Countif Problem (or suggestion for alternative) 6

Back
Top