How can I stop Excel from autoformatting as DATE?

  • Thread starter Thread starter Mike F.
  • Start date Start date
M

Mike F.

I have a cel in which I am trying to enter a PO# of 10- 8348. Even
though the cel is not formatted to adhere to a Date formatting (it is
set to General), whenever I exit the cel, the data converts to
'Oct-48'

I don't want it to do this! I can't find where in the Autoformat
potions I can turn this off.

Any help?

-mike
 
Mike,

Short of turning the machine off, the only thing that comes to mind is to
format the cell (before you enter the stuff) as Text. Format - Cells -
Number - Text. Or precede each with an apostrophe.

'

Earl Kiosterud
mvpearl omitthisword at verizon period net
 
Another way is to format the cell using the Custom option, in the typ
box enter ##"-"### this will allow you to enter the whole number 10834
and will give an output of 10-8348 always showing 4 digits after th
"-"

Hope this helps

Mik
 
Back
Top