Date Format

J

Joseph

Hi,

Pls help me to change the date format of the dates in my
file. Whatever I do, the date still shows, 37803, while
the formula bar shows the correct date as "01/07/2003".
Ive tried Text to columns and Format cells, but no luck.

Joseph
 

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 Formats 4
countifs Function not giving desired result with date criteria 2
Date Format 10
separating date and time 5
Subtracting time...again 2
How to add day to PWA 2016 date format? 0
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Problem using IF statement with dates as part of the formula 4

Top