Automatic date formatting

G

Guest

How do you insert the sequence "10-8-6" onto a worksheet without it
automatically translating the format into the date 10/08/2006?
 
R

Roger Govier

Hi

Or, place a single quote ' before your entry. It won't show up in the cell,
only in the formula bar, and will tell Excel to treat the value as text.

Regards

Roger Govier
 

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

date excel 2
How to remove the automatic date format? 3
Long Date - Long Date = text is days 2
Lookup and dates 5
Help, please 1
Date Calculation Problem 4
Change General format to Date format 2
Delete columns values inbetween 1

Top