Turning off feature that automatically creates dates?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I type, for example, "4-44" (without the quotation marks) into a cell,
Excel automatically transforms the data into a date ("Apr-44").

How do I stop this?

Thanks!

Jason
 
Preformat the cells as Text (format|cells|Number tab)
then do the data entry

or prefix your entry with an apostrophe: '4-44
 
Back
Top