| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I type in 1-2, how can I keep that from defaulting to a date?
Whenever I put 1-2 into Excel, it defaults to 2-Jan....how can I change it,
so it doesnt do that anymore? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I type in 1-2, how can I keep that from defaulting to a date?
Hi!
You have to either preformat the cell as TEXT or precede the entry with an apostrophe: '1-2. The apostrohe will not be visible in the cell. Biff "nickiann18" wrote in message ... Whenever I put 1-2 into Excel, it defaults to 2-Jan....how can I change it, so it doesnt do that anymore? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I type in 1-2, how can I keep that from defaulting to a date?
One way is to type a preceding apostrophe: '
before entering "1-2" Another way is to preformat the column / row as text (via Format Cells Text OK) -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- "nickiann18" wrote in message ... Whenever I put 1-2 into Excel, it defaults to 2-Jan....how can I change it, so it doesnt do that anymore? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula for If Term is on Certain Date then Count | Excel Worksheet Functions | |||
| Recurring annual events using a specific date as a trigger date | Excel Worksheet Functions | |||
| How do you add one date to another? I type in 1/31/05 in A1 and I. | Excel Worksheet Functions | |||
| date and time | New Users to Excel | |||
| Using formulas to determine date in one cell based on date in anot | Excel Worksheet Functions | |||
Linear Mode
