Thread: Leading decimal and zeros in formating numbers
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default Leading decimal and zeros in formating numbers
Maybe,

Tools|Options|edit

and un-check fixed decimal places

Mike

"DLJames" wrote:

All the sudden my worksheet started adding a decimal and 10 zeros to my
number entries. I've tried to format the cell/column again, but it won't
change. What have I done and how do I fix it?
Reply With QuoteReply With Quote