Jul 20 2019 08:47 AM
Hi,
I've never come across this before but I cannot find a fix.
I've extracted a report from a company system. On the company system, the reference shows as 123_ABC. The report is populated into Excel and the reference still shows as 123_ABC. When I copy and paste that report into my own Excel spreadsheet, the reference shows in the cell as ABC_123. However, when I select the cell, the reference shows in the formula bar as 123_ABC. Within this same book, if I now type "1 Week" it's automatically changed to "Week 1". All cells are set to 'General' Formatting and there's no Conditional Formatting within the book.
Any ideas on what's causing this?
Jul 20 2019 08:54 AM
Jul 20 2019 09:05 AM
Jul 20 2019 09:10 AM
SolutionJul 20 2019 09:10 AM
Solution