View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default Excell 2003 Cell format issue

hi
check this....
2003
on the menu bar...
toolsoptionsedit tabuncheck fixed decimal paces.

regards
FSt1

"rbharris" wrote:

I have an end-user that when she types a value such as 150100 into a cell, in
any cell of any spreadsheet of any workbook, she will get a result of 150 or
150.1 but the formatting on the cell is set to General and we tried Number.
What other settings would affect a number value of a cell and how it's
formatted?

Also, I checked for templates and found none.