Windows Thread, Extra apostrophes in Excel in Technical; Ok strange one here. For one user (a fiddler) an XML sheet opened with excel shows apostrophes before just about ...
30th April 2008, 01:35 PM #1
Extra apostrophes in Excel
Ok strange one here. For one user (a fiddler) an XML sheet opened with excel shows apostrophes before just about every cell value. Anyone else looking at the sheet doesn't seem them. So anyone else will 5a, he will see '5a. Now he has his own startup Excel sheet but deleting that didn't stop it. Doing a google search just seems to bring up how to remove extra characters from a badly imported sheet. Ohh and the original XML sheet doesn't have them in.
Any one any ideas?
EDIT: Ohh the other thing is it only shows in the formula bar. Not in the actual cell
Last edited by TechMonkey; 30th April 2008 at 01:52 PM.
IDG Tech News
30th April 2008, 01:53 PM #2
That single quote is saying the cell contents is text - you can type '123 (say) into a cell and Excel will treat ist as text rather than as a number.
I will have a hunt round to see why it is being displayed... it must be an option somewhere.
30th April 2008, 01:58 PM #3
Ta, I've had a look at all the options I can think of and nothing jumps out. It has to be somethign turned on though as I've just noticed that header cells that have the title vertically have the ^ before them as well. Grrrrr, I hate fiddelers that don't know how to fix things they do!!
30th April 2008, 02:06 PM #4
Found it. Took much hunting down. It is text alignment prefix characters found under
(Tools > Options)(Transition tab, "Transition Navigation Keys").
30th April 2008, 02:09 PM #5
a quick fix would be in an empty col enter the formula
assuming col 'A' is the col you want to remove the first char from.
fill down and you should be done.
30th April 2008, 02:14 PM #6
Originally Posted by TechMonkey
Well done, I've bookmarked this thread as I'll never find it when it happens to someone here!
30th April 2008, 02:33 PM #7
Ahhhh, but when you delete the characters they reappear as it is linked to the formatting not the actual content. Well as far as I can see. It looks like it is some obscure remnant of Lotus 1-2-3 and compatibilty options MS have left in for those changing over. You end up having to either have a ' for left align, a ^ for center align or " for right align.
Originally Posted by jmcdermott
By mmoseley in forum How do you do....it?
Last Post: 12th October 2007, 06:44 PM
By danIT in forum Windows
Last Post: 23rd May 2006, 10:20 AM
By Geoff in forum Windows
Last Post: 23rd January 2006, 04:24 PM
By beeswax in forum General Chat
Last Post: 10th January 2006, 10:38 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Tags for this Thread