| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Date auto fill
Every time I put in #-## excel changes it to a date. Where do I turn this
feature off? |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Date auto fill
Prefix with ' to enter it as Text
Or preset the cell to Text format. Steve On Tue, 31 Oct 2006 20:59:42 -0000, Chris wrote: Every time I put in #-## excel changes it to a date. Where do I turn this feature off? |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Date auto fill
Pre-format the cell(s) as text or preface #-## with an apsotrophe which will not
be visible in the cell. Gord Dibben MS Excel MVP On Tue, 31 Oct 2006 12:59:42 -0800, "Chris" wrote: Every time I put in #-## excel changes it to a date. Where do I turn this feature off? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto Date with Manual Entry Protection | Excel Worksheet Functions | |||
| Should be easy...Auto Date Fill | Excel Discussion (Misc queries) | |||
| the auto date feature is not functioning properly - how to reset | New Users to Excel | |||
| stop auto fill from thinking for itself!!!!!!! | New Users to Excel | |||
| Does Excel support Auto fill on filtered data? | Excel Discussion (Misc queries) | |||
Linear Mode
