| Home |
| Search |
| Today's Posts |
|
#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? |
| 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) | |||
Threaded Mode
