For example, if you want to add 9-7-2000 but it is getting changed to date 09-07-2000, you can add an apostrophe before the number like ‘9-7-2000. It will be shown as 9-7-2000. 3] Use Paste Special ...

The Number format in Microsoft Excel is quite powerful, but sometimes it will fail to work, and that’s a problem for advanced users. When this happens, Excel will not recognize values as numbers.