Dates 01/1/02005 comes u ps as 0.011111111

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

Guest

When I format for dates in a column I get this bogus number. How can I fix it
so the column reads the date entries?????
Thank you
 
Discounting the typo, maybe you have a Lotus 123 setting enabled.

Tools|Options|Transition Tab
Uncheck Transition Formula Entry

(I unchecked all those Lotus 123 settings.)
 
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

Access Running Balance in Access 1
Remove date format? 3
Converting date format 4
Date separator 1
Look up across multiple sheets 1
formatting 6
Please help! date showing as 1900/01/00 2
Why this paste result? 4

Back
Top