date excel

[Guest]

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?

 

[Bob Phillips]

Precede it with a single apostrophe '

--

HTH

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

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?

 

[Guest]

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