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 |