ExcelBanter - Use dash without changing it to a date?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Use dash without changing it to a date? (https://www.excelbanter.com/excel-discussion-misc-queries/132888-use-dash-without-changing-date.html)

Markman

Use dash without changing it to a date?

How can I use dash without it automatically changing to a date?

Niek Otten

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?

All times are GMT +1. The time now is 07:02 PM.