Turning off feature that automatically creates dates?

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
 
D

Dave Peterson

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

switch off transforming number into date 1
Differences Between Two Spreadsheets ? 1
Auto Input Today's Date 3
Stop automatic formatting of cells (number, text, date, etc) 4
Remove automatic date formatting 2
How to keep loaded file's format intact? 1
Adding fiscal years ... 5
Cell colour according to date 2

Top