date excel

G

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?
 
B

Bob Phillips

Precede it with a single apostrophe '

--

HTH

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


No brain said:
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
Click to expand...
11/11/2005?
 
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Converting to date format 1
Date Probleme 5
Month 1
Date Menace 2
Converting hijri date to gregorian date 3
Date Entry Problem 4
formatting dates 12
Date Display 4

Top