replacing dates

Christine

New Member
Joined
Feb 25, 2002
Messages
2
I have a problem with a dataset in which I have 3 sets of dates that were apparently entered as text, instead of as dates and look like mm/dd/yy. When I formatted each column to be date mm/dd/yyyy, no change takes place. How do I change 12,000 dates to say mm/dd/2001 instead of mm/dd/01? I tried replace ??/??/01 with ??/??/2001 and that didn't work. Thanks in advance!
 

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.
(Sorry, didn't see Juan's post.)

try highlighting your column and using text to columns under the data menu.

You will probably just be able to away other with just hitting finish when the wizard pops up.

Otherwise, hit next, next again, select the date radio dial with MM/DD/YY.

Another option would be to put 1 in cell, copy it, and paste special multiply over your column.

Good luck

On 2002-02-26 07:58, Christine wrote:
I have a problem with a dataset in which I have 3 sets of dates that were apparently entered as text, instead of as dates and look like mm/dd/yy. When I formatted each column to be date mm/dd/yyyy, no change takes place. How do I change 12,000 dates to say mm/dd/2001 instead of mm/dd/01? I tried replace ??/??/01 with ??/??/2001 and that didn't work. Thanks in advance!
This message was edited by IML on 2002-02-26 08:08
This message was edited by IML on 2002-02-26 08:09
 
Upvote 0

Forum statistics

Threads
1,213,532
Messages
6,114,177
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top