Announcement

Collapse
No announcement yet.

Insert Decimal Into Whole Number

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

  • Insert Decimal Into Whole Number

    I need to add back the decimal place into a set of numbers
    i.e 4825 = 48.25
    125462 = 1254.62

    basically our accounting system has removed the decimal points and I need to add them back

    is there a formula to do this ?

    regards

    Lampit

  • #2
    Re: Insert Decimal Into Whole Number

    Go to Tools >Options > Edit > Fixed decimal places 2
    Kris

    ExcelFox

    Comment


    • #3
      Re: Insert Decimal Into Whole Number

      Hi,

      If there are always two decimal places then just divide by 100

      e.g. in B1

      =A1/100

      Eric

      Comment


      • #4
        Re: Insert Decimal Into Whole Number

        No way for anyone or anything to know the ORGINAL number values. Check your back-up...

        Comment

        Working...
        X