+ Reply to Thread
Results 1 to 4 of 4

Excel Rounding off numbers

  1. 08-10-2010, 02:44 PM #1
    vikas.bhandari
    vikas.bhandari is offline
    Forum Contributor vikas.bhandari's Avatar
    Join Date
    04-07-2006
    Location
    Delhi, India
    MS-Off Ver
    Office 2007 and 2010
    Posts
    303

    Question Excel Rounding off numbers

    Hi there!!

    I am sure I am missing something stupid....but whenever I enter this number : "1202060000028309", Excel rounds off automatically. Why??? Can someone please explain?

    Thanks,
    Vikas
    Last edited by vikas.bhandari; 08-16-2010 at 12:35 PM.
    Reply With QuoteRegister To Reply
  2. 08-10-2010, 02:49 PM #2
    DonkeyOte
    DonkeyOte is offline
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Excel Rounding off numbers

    Excel works to 15 significant digits.
    My Recommended Reading:

    Volatility
    Sumproduct & Arrays
    Pivot Intro
    Email from XL - VBA & Outlook VBA
    Function Dictionary & Function Translations
    Dynamic Named Ranges
    Reply With QuoteRegister To Reply
  3. 08-10-2010, 02:59 PM #3
    zbor
    zbor is offline
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,607

    Re: Excel Rounding off numbers

    You can save it as text...

    write ' and paste number
    Reply With QuoteRegister To Reply
  4. 08-10-2010, 03:49 PM #4
    Cheeky Charlie
    Cheeky Charlie is offline
    Forum Expert
    Join Date
    08-27-2008
    Location
    England
    MS-Off Ver
    2010
    Posts
    2,561

    Re: Excel Rounding off numbers

    http://office.microsoft.com/en-us/ex...005199291.aspx

    For more info

    ...

    oh look! .aspx (only one person will get this)
    CC


    If you feel really indebted please consider a donation to charity. My preferred charity is ActionAid but there are plenty of worthy alternatives.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1