data alteration

B

ben87y

how do I stop excel from altering inputted data?

eg "03/2009" is reformatted to 01/03/2009, or Mar-09, seemingly at random

I've tried right click> format call> then selecting general, but it
constantly reverts back to a "date" display.

Can I turn off this "autocorrect" alltogether somewhere?

Thanks Ben
 
T

T. Valko

Can I turn off this "autocorrect" alltogether somewhere?

Unfortunately, no.

What you can do is preformat the cell as TEXT or precede the entry with an
apostrophe, like this: '03/2009. The apostrophe will not be displayed in the
cell.
 

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

Top