View Single Post
  #3   Report Post  
Gord Dibben
 
Posts: n/a
Default

Justin

ToolsOptionsEdit. Uncheck "fixed decimal places"


Gord Dibben Excel MVP

On Sat, 19 Feb 2005 22:37:03 -0800, Justin
wrote:

Hi,
For some reason whenever I enter numbers into Excel 2003 now without the =
sign beforehand, the number shows up as if I divided it by 10,000 (i.e. 1
becomes .0001). I don't know what I did to start this problem but I can't
figure out how to solve it.
Thanks for any help,
Justin