| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to stop the auto-format of dates?
Hi,
first of all, I am an absolute excel novice and never used it until today, so, forgive me if my question is stupid (for an experiencedExcel user) OK, the problem is simple, I want to insert the following value into a cell: 1/08 . But excel changes it always into a date. It becomes "01 Aug", and if I double click on it, it becomes "01.08.2009". How to stop this auto-correction? My "1/08" is not a date, but a transaction number, so a auto transformation of that value is not wanted. I am using Excel 2007 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| STOP auto format of cell contents | Excel Discussion (Misc queries) | |||
| Stop cell auto format in Excel - SOLUTION! | Excel Discussion (Misc queries) | |||
| how do i stop the auto format on excel? | Excel Discussion (Misc queries) | |||
| stop dates format automatically excel 2002 | Excel Discussion (Misc queries) | |||
| How do I stop auto converting Text(Inventory#) to Dates | Excel Discussion (Misc queries) | |||
Threaded Mode
