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