View Single Post
 
Old 10-19-2011, 07:52 AM
Colin Legg's Avatar
Colin Legg Colin Legg is offline Windows 7 32bit Office 2010 32bit
Expert
 
Join Date: Jan 2011
Location: UK
Posts: 369
Colin Legg will become famous soon enough
Default

Hi,

Yes, it is. The custom format you're looking for is:

#,##0.00

and this will always display 2 decimal places.

So that decimal places are not shown when the cell contains a whole number you could use a conditional formatting rule with a formula like this:
=A1=TRUNC(A1)

and setting the conditional formatting custom format as #,##0
Reply With Quote