If you use the General format, it will show the number of decimals that
you've entered in the cell.

Pete wrote:
is there anyway I can apply a custom format to cells that
can show either whole numbers, or decimals points e.g

A1=15
A2=15.5

I would like this to be the standard for all cells in my
sheet.

I know you can apply Custom formats using [ ] etc.

Thanks

Pete



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html