Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 4 of 4

Thread: Insert Decimal Into Whole Number

  1. #1
    Join Date
    23rd October 2006
    Posts
    20

    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

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    18th November 2004
    Location
    God's Own Country
    Posts
    4,285

    Re: Insert Decimal Into Whole Number

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

  3. #3
    Join Date
    9th June 2007
    Posts
    70

    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

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    24th January 2003
    Location
    Australia
    Posts
    31,705

    Re: Insert Decimal Into Whole Number

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

Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Round Up/Down Based On Decimal Number
    By lps in forum EXCEL HELP
    Replies: 3
    Last Post: May 14th, 2008, 11:42
  2. Round Decimal Number Based On Decimal Portion
    By sk8salomon in forum EXCEL HELP
    Replies: 2
    Last Post: February 8th, 2008, 12:17
  3. Seperate Decimal & Whole Number
    By gazutz in forum EXCEL HELP
    Replies: 4
    Last Post: September 23rd, 2007, 19:19
  4. Round Off Decimal Number To Whole Number
    By khenzel in forum EXCEL HELP
    Replies: 2
    Last Post: September 19th, 2007, 23:46
  5. Calculate Decimal Portion Of Decimal Number`
    By combsgroup in forum EXCEL HELP
    Replies: 2
    Last Post: June 11th, 2007, 12:28

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