microsoft office training excess - Mixing cells with whole and decimal numbers

The UK's most regular instructor-led training courses.
Training information: microsoft office training excess · Excel in courses · Microsoft Excel Training
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Mixing cells with whole and decimal numbers

David has attended:
Word Advanced course
Excel Intermediate course

by - delegate David [3 posts] (2006 Nov 21 Tue, 16:10) Reply

If one wished to show numbers to decimal places in a column where an entry is not an whole number, but not have .00 if an entry is a whole number is that possible and how does one do it?

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Jul 9 Wed	Bloomsbury	0	FULL
2003/XP	2008 Jul 9 Wed	Bayswater	2	book now	£195	£205
2003/XP	2008 Jul 16 Wed	Tooting	0	FULL
2003/XP	2008 Jul 16 Wed	Bloomsbury	1	book now	£235	£240
2003/XP	2008 Jul 18 Fri	Southwark	4	book now	£224	£235
2003/XP	2008 Jul 23 Wed	Southwark	0	FULL
Full Schedule: See all 143 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: Mixing cells with whole and decimal numbers

by - trainer Richard platinum contributer [761 posts] (2006 Nov 22 Wed, 10:30) Reply

Hi David

By default cells are formatted so that if you enter a number with a decimal, it shows decimals, and if you enter a whole number it will only show the number.

However, if there is additional formatting on the cell (like currency, or comma formats), then the number is forced to show the decimal.

So, you could format the cells to their original state.

Select the relevant cells, Right-Click, FORMAT CELLS.
Chose the GENERAL number format (top).
Click OK.

That should do it.

Richard