How do you insert the sequence 11th of November 2005 onto a worksheet without
it automatically translating the format into the date 11-nov-05 or 11/11/2005?

Precede it with a single apostrophe '

--

HTH

RP
(remove nothere from the email address if mailing direct)


"No brain" <No wrote in message
...
How do you insert the sequence 11th of November 2005 onto a worksheet
without
it automatically translating the format into the date 11-nov-05 or
11/11/2005?

format the cell as Text before you enter the value, or precede the value with
an apostrophe


"No brain" wrote:

How do you insert the sequence 11th of November 2005 onto a worksheet without
it automatically translating the format into the date 11-nov-05 or 11/11/2005?