ExcelBanter - Copy/Paste Special (Date Format)

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

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

- - Copy/Paste Special (Date Format) (https://www.excelbanter.com/excel-discussion-misc-queries/111783-copy-paste-special-date-format.html)

Saxman

Copy/Paste Special (Date Format)

When I copy data such as 5/6 or 10-4, how do I prevent Excel from
formatting it to a date when I paste it? I still have this problem,
even though I pre-format the cells to text.

All times are GMT +1. The time now is 09:05 PM.