Excel 2003 Date format

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Rainman50

Thread Starter
Joined
Feb 6, 2004
Messages
70
I have an existing Excel spreadsheet that contains the date format mm/dd/yyyy. I want to convert it to mm/dd/yy. Excel will not convert the current cells to the new format without re-entering the information. Can anyone help? Thanks in advance.
 
Joined
Jul 25, 2004
Messages
5,458
Select the cell, press Ctrl + 1, Number (tab), select date and the date format you want. No changing of the cell values needed, only format.
 

Rainman50

Thread Starter
Joined
Feb 6, 2004
Messages
70
I tried this, it does not change the current info. The information has to be re-entered. The cell is formatted, but the currnet date format is not edited.

I want to change xx/xx/xxxx to xx/xx/xx.
 
Joined
Jun 24, 2004
Messages
114
It sounds like your cells contain text and not 'proper' dates. If so ...

Put zero in an unused cell somewhere - and Copy it.
Select your dates and Paste Special > Add
Now try and format them again.
 

Rainman50

Thread Starter
Joined
Feb 6, 2004
Messages
70
Sorry, no go. Not sure what is going on with this doc. Thanks for your help!
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Members online

Top