Thread: when i enter a price like 16.50 the zero get cut off 16.5
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
[email protected] joeu2004@hotmail.com is offline
external usenet poster
  
Posts: 418
Default 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.

Reply With QuoteReply With Quote