Forum Discussion
Solved
Question Regarding XLookup/Numbers Stored as Text
Hoping someone can provide some insight...might be an easy answer but I haven't encountered a lot of number stored as text issues before. Basically I'm working on a spreadsheet that has identifie...
cguma77
Please see the attached file...
cguma77 You don't really need the apostrophe, as long as you format both columns consistently See attached.
Thanks for the answer! Few quick follow ups to that:
-Some of the identifiers do have a mix of letters, numbers, some all numbers, Do I still not need the apostrophe?
-What I'm really confused on is why excel is registering the unedited column differently than the edited one. The values in both are exactly the same. Is there a format on the cell that I'm missing?
Thanks again for the advice, really appreciate it.
-Some of the identifiers do have a mix of letters, numbers, some all numbers, Do I still not need the apostrophe?
-What I'm really confused on is why excel is registering the unedited column differently than the edited one. The values in both are exactly the same. Is there a format on the cell that I'm missing?
Thanks again for the advice, really appreciate it.
cguma77 Don't really understand. where does the data come from? Why are there apostrophes in the first place?
- The data came from a client pre-formatted with the apostrophes, and there's a ton of them already in there, but their formatting isn't consistent across different sheets that needed to reference each other. Someone added a substitution to the xlookup that circumvented the issue so that will work for me! Thank you again!