Disapearing zero after decimal point

[Custom_S]

I have converted a DOS file into excel and I needed to add a decimal point to some of the data. Through this site I found out how to add the decimal point that I needed by putting 10 in an empty cell and then copy it and then selecting the cells I need to change and doing a Paste Special and divide but my problem is if the number ends in zero the zero disapears for example the number is 1250 and I need it to be displayed as 125.0 not 125. All the data is in text. How can I keep the zero's from disapearing. Thanks in advance

[Will Riley]

You need to convert the numbers stored as text to numerical data first and then divide by ten.

You can usually do this using the same method, but place a 1 in a cell, copy it, select your text data & using pastespecial>multiply.... then do your division by 10.

[Custom_S]

Will,

Thank you so much for your help, I tried your "trick" but it did not work but you did give me another idea. What I had to do was divide by the 10 then go to format cells and change the data to number with 1 decimal place and it WORKED.

Thanks again I really appreciate it,
Custom_S

[PA HS Teacher]

To turn 1250 into 125.0, you can use:
TEXT(A1/10,"0.0")

Paste down in an unused column.
(can copy paste special as values over the orignal column if necessary)

An example of several examples of the data, as well as several examples of what it should look like when you're done would be helpful.

[Custom_S]

PA HS Teacher,

Thank you for the help. The column that I had to convert has over 19800 records in them it looks like this

1386
1250
1875
1467
1770
1323
etc.....

I needed it to look like this

138.6
125.0
187.5
146.7
177.0
132.3
etc.......

It worked when I put 10 in an empty cell and then copyied it then I selected the data I needed converted did a Paste Special selected divide hit okay then I went to Format, selected number and changed the decimal point to 1.

Thanks again,

Custom_S