Dates change into number automatically

pranamu

New Member
Joined
Nov 2, 2011
Messages
47
Hi Genius,

When I open my files after saving it will get changed automatically. Suppose I changed all the number format into dates and save the file but when I reopen those date see as number. Please can you advise how do I stop it so that every time my dates column will be seen as dates instead number.
 

Some videos you may like

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
54,456
Office Version
  1. 365
Platform
  1. Windows
What version of Excel are you using?
What is the format and extension of the file you are saving?
 

Watch MrExcel Video

Forum statistics

Threads
1,108,911
Messages
5,525,588
Members
409,652
Latest member
strangelyangely

This Week's Hot Topics

Top