Technology1 min ago
Help with Excel
4 Answers
Hi All
Ive got a problem with a file i am using. It is a long list of numbers. When you are not in the cell the number looks like this:
ABC1234
When you double click in the cell it changes to this:
'ABC1234 and this also appears in the function bar at the top when you just click on the cell once.
I cannot get rid of this ' . I have tried find and replace, format cells, paste special, text to columns etc. Any1 help?????
Answers
Best Answer
No best answer has yet been selected by BigB. Once a best answer has been selected, it will be shown here.
For more on marking an answer as the "Best Answer", please visit our FAQ.