Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 5 of 5

Thread: Disapearing zero after decimal point

  1. #1
    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. #2
    Join Date
    28th January 2003
    Location
    Solihull - England
    Posts
    8,678

    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.
    Kind Regards, Will Riley

    Web Presence:
    LinkedIn: Will Riley

  3. #3
    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. #4
    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. #5
    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


Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Convert Decimal With Comma To Decimal With Point
    By neverland in forum EXCEL HELP
    Replies: 4
    Last Post: June 3rd, 2011, 20:11
  2. Return Nth Value To Right Of Decimal Point
    By dpw in forum EXCEL HELP
    Replies: 13
    Last Post: February 12th, 2009, 15:08
  3. Replies: 2
    Last Post: August 8th, 2008, 19:17
  4. Increment Second Decimal Point
    By sujittalukder in forum EXCEL HELP
    Replies: 11
    Last Post: May 15th, 2007, 15:58
  5. Inserting decimal point
    By DHunter in forum EXCEL HELP
    Replies: 3
    Last Post: February 17th, 2005, 08:32

Bookmarks

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