Hi

You must use code to do this or enter the date with a short cut

Ctrl ;

Or with code

Sub test()
ActiveCell.Value = Format(Date, "dd-mmm-yyyy")
End Sub


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Kanaski79" wrote in message ...
Ok I have another question.

With the =today() function is there a way to automaticaly make the date a
value so It will not change again, say once you mail the file, or when you
post it to web folder or something?

Thanks guys.

Kevin