Announcement

Collapse
No announcement yet.

Disapearing zero after decimal point

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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

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

    LinkedIn: Will Riley

    Comment


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


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


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

          Working...
          X