|
Posted to microsoft.public.excel.newusers
|
|
|
when i enter a price like 16.50 the zero get cut off 16.5
Pre-format the cell to 2 decimal places.
FormatCellNumberNumberDecimal Places..2
Gord Dibben MS Excel MVP
On Sun, 15 Oct 2006 15:57:01 -0700,
. com wrote:
how do i keep the zero on the price sheet using excel. $16.50
|