ExcelBanter - when i enter a price like 16.50 the zero get cut off 16.5

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - when i enter a price like 16.50 the zero get cut off 16.5 (https://www.excelbanter.com/new-users-excel/114519-when-i-enter-price-like-16-50-zero-get-cut-off-16-5-a.html)

[email protected]

when i enter a price like 16.50 the zero get cut off 16.5

how do i keep the zero on the price sheet using excel. $16.50

[email protected]

when i enter a price like 16.50 the zero get cut off 16.5

wrote:
how do i keep the zero on the price sheet using excel. $16.50

Select the cell or column or range of cells, then on the tool bar click
on Format Cells Number. Select Number or Currency and be sure that
Decimal Places is 2.

Gord Dibben

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

Bernard Liengme

when i enter a price like 16.50 the zero get cut off 16.5

....and note that you do not need to type the final zero. Enter 16.5 to get
16.50
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
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

All times are GMT +1. The time now is 12:19 PM.