View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PCLIVE PCLIVE is offline
external usenet poster
 
Posts: 65
Default why do zeros after decimals drop out of excel

Reformat your cells. Highlight the cells you want as currency. Right-click
and goto 'Format Cells'. On the 'Number' tab, select 'Currency'. You can
then set the number of dicimal places.

"Bc Curious" <Bc wrote in message
...
I'm doing a spread sheet with dollar values in excel worksheet. Each time
the
dollar value ends in one or two zeros after the decimal the zeros drop out
as
I move to the next cell. Why?