how to replace the date

M

mangesh

hi kabel,
i have put the date 03/03/2004 in a worksheet in various cells, i woul
like to replace that date with 03/04/2004.
pls help me
 
F

Frank Kabel

Hi
try the following
- goto 'Edit -Replace'
- enter your existing date and your new date

P.S.: please stay in the original thread
P.P.S. My first name is Frank :)
 
N

Norman Harker

Hi Mangesh

Use:

Edit > Replace

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Top