Date Value

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

Guest

G'Day,

The date in my excel sheet is formatted to the serial number, I cannot get
it back to display the date in year/month/day format. I am not too sure why
and I have looked for answers in the help menu with no luck.

Thanks For the Help
 
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

Help with date format mm/dd/yyyy vs. dd/mm/yyyy 3
How to display a date 1
Remove date format? 3
format text to date results in ############## 4
yearfrac format error? 4
Excel VBA to go to specific sheet & cell in the current workbook not working. 2
converting dates from file 3
Excel 2003 keeps on changing the date that i entered. HELP PLEASE 1

Back
Top