dates and numbers

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

Guest

hi there, every time i type in a number in an excel cell,
it is automatically converted into a date. i turned off
auto complete, tried format, cell, number, but nothing
works. any ideas and suggestions? it would be greatly
appreciated.
 
What, exactly, are you typing? If it looks like a date, say it has slashes or
dashes, Excel tries to interpret it as a date. What happens if you clear the
formatting for these cells AFTER you've entered the data?
 
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

Need to open eer file without converting 8-7440 to a date? 1
Auto date in excell 2010 4
converting date to text 2
Replace numbers with time 3
How can I stop Excel from formating my infromation as a Date? 2
Is it possible to get Excel to stop formatting text as a date? 2
Data being corrupted by excels automatic date recognition re-forma 6
counting dates using SUMPRODUCT 4

Back
Top