why do zeros after decimals drop out of excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 
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.
 
Did you format the cell for 2 decimals? If you go to Format/Cells/ on the
number tab select Currency. It defaults to 2 decimals, you can add more if
needed - you can also select to show the $ or not. Once you format the
Column(s) you shouldn't have any problem...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

excel 2003 zero as last decimal 5
Convert $ amount from excel to access? No decimals but 00 at end 1
Decimal point will not hold 2 places in Excel 2003 3
Decimal point in general format 1
Trailing zeros 5
Formula Using Vlookup & Match 3
Excel Stop Excel from displaying rounded values 4
Displaying zeros in cells 2

Back
Top