Thread: In Excel how do I get 2 zeros to show automatically after I enter.
View Single Post
  #1   Report Post  
Jackson
 
Posts: n/a
Default In Excel how do I get 2 zeros to show automatically after I enter.
I am using Excel 2003. I have set my options to a fixed decimal with 2
places. When I enter 1495 the cell shows 14.95 but when I type in 14. the
cell shows .14. How do I get 14.00 without entering the zeros?

Reply With QuoteReply With Quote