View Single Post
  #2   Report Post  
Henry
 
Posts: n/a
Default

Todd,

Put an apostrophe before the first 0.
'0700
Excel will treat this as text.
You won't be able to do any calculations with it though.

Henry

"Todd" wrote in message
...
I am trying to get the number 0700 to appear as 0700 in a cell, not as 700.
When I type it in, Excell automatically corrects what it thinks is a
mistake.
Is there a way to make it appear as 0700?