The REPT function repeats 'whatever' the number of times you set it to, it
will only work with a date if you set it to repeat once which is obviously
pointless. I dont think thats what you want here. If you have the date in
for instance A6, in all the other cells enter =A6
Regards,
Alan.
"ROCKWARRIOR"
wrote in message
...

I am trying to repeat dates in several different places, so that I only
have to type it once. However, when I use the REPT function I get a
number instead of a date format. I've tried to format the cells back to
date function, but it doesn't change.


--
ROCKWARRIOR
------------------------------------------------------------------------
ROCKWARRIOR's Profile:
http://www.excelforum.com/member.php...o&userid=27091
View this thread: http://www.excelforum.com/showthread...hreadid=468286