How to code the macro?
 

Does anyone have any suggestions on how to code the macro?
There is text in cell A1 22-Aug-2002, which is not belong to date format
until I press F2 and enter, then it will change to 22-Aug-02.
I have a table from A1 to Z5000, does anyone have any suggestions on how to
create a macro to perform this task within this range?
Thanks in advance for any suggestions
Eric

How to code the macro?
 

hi Eric,

You don't need a macro:
1. enter the number '1' into any empty cell
2. copy the '1'
3. select the date range and choose Edit|Paste Special Values Add OK
4. if necessary, reformat the cells with the appropriate date format.

--
Cheers
macropod
[Microsoft MVP - Word]


"Eric" wrote in message ...
Does anyone have any suggestions on how to code the macro?
There is text in cell A1 22-Aug-2002, which is not belong to date format
until I press F2 and enter, then it will change to 22-Aug-02.
I have a table from A1 to Z5000, does anyone have any suggestions on how to
create a macro to perform this task within this range?
Thanks in advance for any suggestions
Eric

How to code the macro?
 

Macropod,

I think you mean Paste Special - Multiply (Not add).


--
Regards,

OssieMac


"macropod" wrote:

hi Eric,

You don't need a macro:
1. enter the number '1' into any empty cell
2. copy the '1'
3. select the date range and choose Edit|Paste Special Values Add OK
4. if necessary, reformat the cells with the appropriate date format.

--
Cheers
macropod
[Microsoft MVP - Word]


"Eric" wrote in message ...
Does anyone have any suggestions on how to code the macro?
There is text in cell A1 22-Aug-2002, which is not belong to date format
until I press F2 and enter, then it will change to 22-Aug-02.
I have a table from A1 to Z5000, does anyone have any suggestions on how to
create a macro to perform this task within this range?
Thanks in advance for any suggestions
Eric

.

How to code the macro?
 

Try DataText To Columns. Step 3 has a date formatting option.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Eric" wrote in message
...
Does anyone have any suggestions on how to code the macro?
There is text in cell A1 22-Aug-2002, which is not belong to date format
until I press F2 and enter, then it will change to 22-Aug-02.
I have a table from A1 to Z5000, does anyone have any suggestions on how
to
create a macro to perform this task within this range?
Thanks in advance for any suggestions
Eric

How to code the macro?
 

Multiply will change the date value, which is not what I want.
I have tried Press F2 and Press Enter on each cell, which is only working
approach.
Do you have any suggestions?
Thank everyone very much for any suggestions
Eric

"OssieMac" wrote:

Macropod,

I think you mean Paste Special - Multiply (Not add).


--
Regards,

OssieMac


"macropod" wrote:

hi Eric,

You don't need a macro:
1. enter the number '1' into any empty cell
2. copy the '1'
3. select the date range and choose Edit|Paste Special Values Add OK
4. if necessary, reformat the cells with the appropriate date format.

--
Cheers
macropod
[Microsoft MVP - Word]


"Eric" wrote in message ...
Does anyone have any suggestions on how to code the macro?
There is text in cell A1 22-Aug-2002, which is not belong to date format
until I press F2 and enter, then it will change to 22-Aug-02.
I have a table from A1 to Z5000, does anyone have any suggestions on how to
create a macro to perform this task within this range?
Thanks in advance for any suggestions
Eric

.

How to code the macro?
 

Eric,


Any numeric value multiplied by 1 does not change its value. If by pressing
F2 then Enter fixes the problem on on individual cells then it appears that
you have already formatted the column to dates. Therefore if you type 1 into
any empty cell, copy that cell then select all of the existing dates and
Paste Special - Multiply then it will fix your problem.

If you are nervous about doing it then try Past Special - Multiply to just
one of the cells and see what it does.

--
Regards,

OssieMac


"Eric" wrote:

Multiply will change the date value, which is not what I want.
I have tried Press F2 and Press Enter on each cell, which is only working
approach.
Do you have any suggestions?
Thank everyone very much for any suggestions
Eric

"OssieMac" wrote:

Macropod,

I think you mean Paste Special - Multiply (Not add).


--
Regards,

OssieMac


"macropod" wrote:

hi Eric,

You don't need a macro:
1. enter the number '1' into any empty cell
2. copy the '1'
3. select the date range and choose Edit|Paste Special Values Add OK
4. if necessary, reformat the cells with the appropriate date format.

--
Cheers
macropod
[Microsoft MVP - Word]


"Eric" wrote in message ...
Does anyone have any suggestions on how to code the macro?
There is text in cell A1 22-Aug-2002, which is not belong to date format
until I press F2 and enter, then it will change to 22-Aug-02.
I have a table from A1 to Z5000, does anyone have any suggestions on how to
create a macro to perform this task within this range?
Thanks in advance for any suggestions
Eric

.

How to code the macro?
 

I get it, and it works now.
Thank everyone very much for suggestions
Eric

"OssieMac" wrote:

Eric,


Any numeric value multiplied by 1 does not change its value. If by pressing
F2 then Enter fixes the problem on on individual cells then it appears that
you have already formatted the column to dates. Therefore if you type 1 into
any empty cell, copy that cell then select all of the existing dates and
Paste Special - Multiply then it will fix your problem.

If you are nervous about doing it then try Past Special - Multiply to just
one of the cells and see what it does.

--
Regards,

OssieMac


"Eric" wrote:

Multiply will change the date value, which is not what I want.
I have tried Press F2 and Press Enter on each cell, which is only working
approach.
Do you have any suggestions?
Thank everyone very much for any suggestions
Eric

"OssieMac" wrote:

Macropod,

I think you mean Paste Special - Multiply (Not add).


--
Regards,

OssieMac


"macropod" wrote:

hi Eric,

You don't need a macro:
1. enter the number '1' into any empty cell
2. copy the '1'
3. select the date range and choose Edit|Paste Special Values Add OK
4. if necessary, reformat the cells with the appropriate date format.

--
Cheers
macropod
[Microsoft MVP - Word]


"Eric" wrote in message ...
Does anyone have any suggestions on how to code the macro?
There is text in cell A1 22-Aug-2002, which is not belong to date format
until I press F2 and enter, then it will change to 22-Aug-02.
I have a table from A1 to Z5000, does anyone have any suggestions on how to
create a macro to perform this task within this range?
Thanks in advance for any suggestions
Eric

.

How to code the macro?
 

Oops ...

--
Cheers
macropod
[Microsoft MVP - Word]


"OssieMac" wrote in message ...
Macropod,

I think you mean Paste Special - Multiply (Not add).


--
Regards,

OssieMac


"macropod" wrote:

hi Eric,

You don't need a macro:
1. enter the number '1' into any empty cell
2. copy the '1'
3. select the date range and choose Edit|Paste Special Values Add OK
4. if necessary, reformat the cells with the appropriate date format.

--
Cheers
macropod
[Microsoft MVP - Word]


"Eric" wrote in message ...
Does anyone have any suggestions on how to code the macro?
There is text in cell A1 22-Aug-2002, which is not belong to date format
until I press F2 and enter, then it will change to 22-Aug-02.
I have a table from A1 to Z5000, does anyone have any suggestions on how to
create a macro to perform this task within this range?
Thanks in advance for any suggestions
Eric

.