Date Format
activecell.Numberformt = "mm/dd/yyyy"
should read
activecell.Numberformat = "mm/dd/yyyy"
--
Regards,
Tom Ogilvy
"Tom Ogilvy" wrote in message
...
activecell.Numberformt = "mm/dd/yyyy"
activecell.Numberformat = "mmm dd, yyyy"
Make sure the date is actually stored as a date and not as a string/text
(which will not format)
assume it is A1
=isnumber(A1)
if that returns false, the it isn't stored as a date.
--
Regards,
Tom Ogilvy
"Neal" wrote in message
...
I have a cell with the date formatted as Jan 01 1967 and I would like to
write an expression to change it to 01/01/1967 but I cant seem to find
an
expression on line that coan help. Is there an expression to change the
date
format?
|