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 said:
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 said:
Macropod,
I think you mean Paste Special -> Multiply (Not add).
--
Regards,
OssieMac
:
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]
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
.
