How can I stop Excel from correcting data in a sp.sheetfor instan.

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

Guest

How can I stop excel from correcting data I put in a cell? For instance, I
type in
1-1 and it automatically makes it Jan00
I want to be able to use the dash without having it be a date.
 
Precede the 1-1 with an apostrophe. I will not show in the cell or in a
print out.
best wishes
Bernard
 
You must log in or register to reply here.

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

Displaying zeros in cells 2
Auto date in excell 2010 4
How do I stop Excel from 'interpreting' my data? 7
Find errors in Excel. 7
Data table is not updating correctly in excel 2003 3
Best method / software for graphical output from dynamic excel data 0
CSV->Excel Data Problem 1
Is it possible to get Excel to stop formatting text as a date? 2

Back
Top