View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Tom is offline
external usenet poster
 
Posts: 8
Default DECIMAL PLACES DISPLAYED

I'm having a problem with how my decimal places are displayed in the
"Formula Bar". I have the number of decimal places set to three for
all of the cells in my spreadsheet, but in certain instances, only one
or two places are all thats being displayed in the Formula Bar. An
example would be 0.500 (in the cell), but 0.5 is displayed in the
Formula Bar. Can someone please head me in the right direction?

Thanks,

Tom T.