Date display in Excel

  • Thread starter Thread starter Clark
  • Start date Start date
C

Clark

Format column of cells as Date, display as mm/dd/yy. Date
entered into cell, shows up correctly in the text entry
field at the top of the screen, but the data on the
worksheet displays as "33747", or similar number. Only
happening on one workbook.
 
Try tools|options|View tab|uncheck Formulas.
Format column of cells as Date, display as mm/dd/yy. Date
entered into cell, shows up correctly in the text entry
field at the top of the screen, but the data on the
worksheet displays as "33747", or similar number. Only
happening on one workbook.
Click to expand...
 
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

date format 1
Excel 2007 displayed dates 2
Excel 2002: How to make the date format uniform ? 1
Date formatting from user form to worksheet 6
Excel 2003 keeps on changing the date that i entered. HELP PLEASE 1
Entering date as MM/DD/YY no longer works, why? 1
Preserving date format 1
Entering dates into cells as mm/yy or yy 4

Back
Top