Thread: when i enter a price like 16.50 the zero get cut off 16.5
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.newusers
Bernard Liengme Bernard Liengme is offline
external usenet poster
  
Posts: 4,393
Default 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





Reply With QuoteReply With Quote