SOLVED
Home

Transposing Numbers and Text

%3CLINGO-SUB%20id%3D%22lingo-sub-765873%22%20slang%3D%22en-US%22%3ETransposing%20Numbers%20and%20Text%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-765873%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20never%20come%20across%20this%20before%20but%20I%20cannot%20find%20a%20fix.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20extracted%20a%20report%20from%20a%20company%20system.%20On%20the%20company%20system%2C%20the%20reference%20shows%20as%20123_ABC.%20The%20report%20is%20populated%20into%20Excel%20and%20the%20reference%20still%20shows%20as%20123_ABC.%20When%20I%20copy%20and%20paste%20that%20report%20into%20my%20own%20Excel%20spreadsheet%2C%20the%20reference%20shows%20in%20the%20cell%20as%20ABC_123.%20However%2C%20when%20I%20select%20the%20cell%2C%20the%20reference%20shows%20in%20the%20formula%20bar%20as%20123_ABC.%20Within%20this%20same%20book%2C%20if%20I%20now%20type%20%221%20Week%22%20it's%20automatically%20changed%20to%20%22Week%201%22.%20All%20cells%20are%20set%20to%20'General'%20Formatting%20and%20there's%20no%20Conditional%20Formatting%20within%20the%20book.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20ideas%20on%20what's%20causing%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-765873%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-765881%22%20slang%3D%22en-US%22%3ERe%3A%20Transposing%20Numbers%20and%20Text%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-765881%22%20slang%3D%22en-US%22%3EPerhaps%2C%20an%20add-in%20is%20causing%20such%20odd%20behavior.%20Try%20to%20disable%20the%20add-ins.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-765882%22%20slang%3D%22en-US%22%3ERe%3A%20Transposing%20Numbers%20and%20Text%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-765882%22%20slang%3D%22en-US%22%3EI%20don't%20use%20add-ins%20but%20going%20through%20File%20%26gt%3B%20Options%20%26gt%3B%20Add-Ins%20I%20can%20see%20that%20there%20are%20none%20currently%20activated.%3CBR%20%2F%3E%3CBR%20%2F%3EThis%20has%20also%20just%20happened%20with%20punctuation%20-%20I%20left%20myself%20a%20note%20ending%20in%20a%20%3F%20and%20when%20I%20hit%20enter%2C%20the%20cell%20displays%20it%20at%20the%20start%20of%20the%20text....%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-765883%22%20slang%3D%22en-US%22%3ERe%3A%20Transposing%20Numbers%20and%20Text%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-765883%22%20slang%3D%22en-US%22%3EOK%20-%20the%20strangeness%20continues%20(but%20it%20hopefully%20resolved).%20After%20a%20good%2045%20minutes%20of%20searching%20through%20options%20and%20posting%20on%20forums%2C%20I%20went%20back%20to%20an%20old%20favourite.%20I%20closed%20Excel%20and%20reopened%20it%20-%20it%20appears%20to%20have%20resolved%20itself!%20The%20entry%20showing%20as%20'%3FDate%20Comitted%20%3D%20Date%20Due'%20when%20I%20saved%20the%20file%20has%20reverted%20to%20'Date%20Committed%20%3D%20Date%20Due%3F'%20upon%20reopening%20it.%3CBR%20%2F%3E%3CBR%20%2F%3EHopefully%20won't%20reoccur.%20Thanks%20for%20your%20time%2C%20Twifoo.%3C%2FLINGO-BODY%3E
Tonste85
New Contributor

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?

3 Replies
Perhaps, an add-in is causing such odd behavior. Try to disable the add-ins.
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....
Solution
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.
Related Conversations
Extentions Synchronization
Deleted in Discussions on
3 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies