Thread
:
why do zeros after decimals drop out of excel
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
PCLIVE
external usenet poster
Posts: 65
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?
Reply With Quote
PCLIVE
View Public Profile
Find all posts by PCLIVE