Forum Discussion
Solved
Transposing Numbers and Text
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 ...
- OK - the strangeness continues (but it hopefully resolved). After a good 45 minutes of searching through options and posting on forums, I went back to an old favourite. I closed Excel and reopened it - it appears to have resolved itself! The entry showing as '?Date Comitted = Date Due' when I saved the file has reverted to 'Date Committed = Date Due?' upon reopening it.
Hopefully won't reoccur. Thanks for your time, Twifoo.
I don't use add-ins but going through File > Options > Add-Ins I can see that there are none currently activated.
This has also just happened with punctuation - I left myself a note ending in a ? and when I hit enter, the cell displays it at the start of the text....
This has also just happened with punctuation - I left myself a note ending in a ? and when I hit enter, the cell displays it at the start of the text....
OK - the strangeness continues (but it hopefully resolved). After a good 45 minutes of searching through options and posting on forums, I went back to an old favourite. I closed Excel and reopened it - it appears to have resolved itself! The entry showing as '?Date Comitted = Date Due' when I saved the file has reverted to 'Date Committed = Date Due?' upon reopening it.
Hopefully won't reoccur. Thanks for your time, Twifoo.
Hopefully won't reoccur. Thanks for your time, Twifoo.