Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Is it possible to format numbers (or currency) in Excel so that there will only be a period when there is not a whole number? For example:

12.43 will appear as 12.43
12 will appear as 12 and not 12.00

Rather than using "General" formatting, I am looking for a way to build on top of the custom format that I am already using: $0.##,,"m";$-0.##,,"m"

share|improve this question
up vote 1 down vote accepted

You could do this by first formatting the numbers to show the two decimal places and then apply a conditional format to format the the whole numbers. A formula like this will find the whole numbers:

=IF(A1-INT(A1)=0,TRUE,FALSE)
share|improve this answer
    
in case anyone reading has not heard of conditional formatting: office.microsoft.com/en-au/excel-help/… – WoodenKitty Nov 2 '14 at 23:28

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .