Thread: Use dash without changing it to a date?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Niek Otten Niek Otten is offline
external usenet poster
  
Posts: 3,440
Default 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 With QuoteReply With Quote