Add a ' in front of the date. However, it's never a good idea to convert
dates/numbers to text.



--
Regards
Dave Hawley
www.ozgrid.com
"fgg" wrote in message
...
Hi there,

I have cells formatted as date (e.g. 11/9/03) and I'd like to change
the format to text. But when I do it, the values change as well (e.g.
"36472"). What can I do to avoid this?

Thanks