Hi Tony
You may want to check Regional Settings under the Control Panel.
Regards
Ammita
-----Original Message-----
From: Tony Greenfield [mailto:[log in to unmask]]
Sent: 10 July 2001 09:44
To: [log in to unmask]
Subject: DATE FORMAT
I want my macro to enter today's date on a worksheet automatically. I
can use the function TODAY() but it insists on using American format
(month/day/year)
Could you please tell me how to assign another format automatically?
Cheers, TONY
--
Tony Greenfield
Middle Cottage
Little Hucklow
Derbyshire SK17 8RT
01298 872326
|