Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Automatic date formatting
How do you insert the sequence "10-8-6" onto a worksheet without it
automatically translating the format into the date 10/08/2006? |
#2
|
|||
|
|||
Automatic date formatting
Format the cell as Text before entering the data.
-- Ian -- "Vidz" wrote in message ... How do you insert the sequence "10-8-6" onto a worksheet without it automatically translating the format into the date 10/08/2006? |
#3
|
|||
|
|||
Automatic date formatting
Thanks Ian
"Ian" wrote: Format the cell as Text before entering the data. -- Ian -- "Vidz" wrote in message ... How do you insert the sequence "10-8-6" onto a worksheet without it automatically translating the format into the date 10/08/2006? |
#4
|
|||
|
|||
Automatic date formatting
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 Vidz wrote: How do you insert the sequence "10-8-6" onto a worksheet without it automatically translating the format into the date 10/08/2006? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Weird Excel date formatting problem | New Users to Excel | |||
date formatting? | Excel Discussion (Misc queries) | |||
Automatic date | Excel Discussion (Misc queries) | |||
Automatic Date Update | Excel Discussion (Misc queries) | |||
Cell / Date Formatting Question when result = -0- | Excel Discussion (Misc queries) |