Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports

# Thread: Disapearing zero after decimal point

1. I agreed to these rules
Join Date
12th June 2005
Posts
8

## Disapearing zero after decimal point

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

Excel Video Tutorials / Excel Dashboards Reports

2. ## 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.

3. I agreed to these rules
Join Date
12th June 2005
Posts
8

## 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

Excel Video Tutorials / Excel Dashboards Reports

4. Member
Join Date
5th May 2005
Location
Hershey, PA
Posts
21

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

Excel Video Tutorials / Excel Dashboards Reports

5. I agreed to these rules
Join Date
12th June 2005
Posts
8

## 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

Excel Video Tutorials / Excel Dashboards Reports

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•
porno