| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Use dash without changing it to a date?
How can I use dash without it automatically changing to a date?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Use dash without changing it to a date?
Format as text before entering the number or precede the number with an apostrophe (which will not show)
-- Kind regards, Niek Otten Microsoft MVP - Excel "Markman" wrote in message ... | How can I use dash without it automatically changing to a date? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell contents changing to date and not date | Excel Worksheet Functions | |||
| Changing date from =NOW() to Creation Date | Excel Worksheet Functions | |||
| understanding dash dash in a excel formula | Excel Worksheet Functions | |||
| how do i stop excel from changing a dash to a zero in a cell? | Excel Worksheet Functions | |||
| When I open my past invoice it keeps changing date to todays date | Excel Worksheet Functions | |||
Hybrid Mode
