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
Announcement
Collapse
No announcement yet.
Disapearing zero after decimal point
Collapse
X

Re: Disapearing zero after decimal point
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.

Re: Disapearing zero after decimal point
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
Comment

Re: Disapearing zero after decimal point
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.
Comment

Re: Disapearing zero after decimal point
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
Comment
Comment