| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i change the default from a date to a number?
hi,
does anyone know how to change the settings so that if a number like 11-20 is entered in a cell, it will stay like that rather than turning into nov-20? i tried changing the setting from date to general, but it then wanted to convert it to a number like 4438. any ideas? many thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do i change the default from a date to a number?
Preformat the cell as Text, or use an apostrophe (') as the first
character in the cell. In article , Habbakuk wrote: hi, does anyone know how to change the settings so that if a number like 11-20 is entered in a cell, it will stay like that rather than turning into nov-20? i tried changing the setting from date to general, but it then wanted to convert it to a number like 4438. any ideas? many thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change Default Number Format | Excel Discussion (Misc queries) | |||
| How do I change default number settings? | Excel Worksheet Functions | |||
| How do I change the default number format ? | Excel Discussion (Misc queries) | |||
| How do I change the default number format in excel? | Excel Worksheet Functions | |||
| How do I change the default number format? | Excel Discussion (Misc queries) | |||
Linear Mode
