Date display in Excel

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.
 
D

Dave Peterson

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...
 

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

Split form 0
VBA - exporting serial letters to single documents 0
Date Formats 4
date format 1
Excel does not accept text format! 0
Excel 2007 displayed dates 2
Date formatting from user form to worksheet 6
How to enter a date in DD-MM-YYYY format 2

Top