Results 1 to 3 of 3

Whole numbers:formatting numbers

Threaded View

trickyricky Whole numbers:formatting... 12-28-2010, 02:59 PM
DonkeyOte Re: Need help formatting... 12-28-2010, 03:14 PM
trickyricky Re: Need help formatting... 12-28-2010, 03:37 PM
  1. #1
    Forum Contributor
    Join Date
    10-30-2010
    Location
    Kansas, USA
    MS-Off Ver
    Excel 2010
    Posts
    100

    Whole numbers:formatting numbers

    I have a list of numbers. Some of them can be very long like 0.156489789 and some can be simply 2, 3, 4, 5 etc...

    I want excel to show them to three decimals only when it needs to.

    eg: if i have a 1 i want it to read 1
    if I have a 3.2 i want it to read as 3.2
    if I have a 5.55 i want it to read 5.55
    if I have a 1.01515151515 i want it to read formatted like 1.015

    I am currently using the number format #,##0.###. This works fine except when I have a whole number like '1' it reads out as '1.' with a decimal after it.

    How can I achieve this to read whole numbers without the decimal and still be able to read out the other 1-3 digits if it needs to?


    Thanks in advance
    Last edited by DonkeyOte; 12-28-2010 at 03:22 PM. Reason: revised title slightly "Need Help" removed.

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1