Entering text in Excel cell

[kirkm]

I'm entering various things that require a leading quote (Single quote
or apostrophe).

Excel stores the character but doesn't display it.
Is there a setting to change or some other way to make it visible?

Thanks - Kirk

 

[Gary''s Student]

Enter the apostrophe twice.

 

[Keith74]

Try entering two apostrophes instead of one.

Have a look at this thread, gives a good explaination of what's going
on.

http://groups.google.co.uk/group/mi...ee8cea9?lnk=gst&q=apostrophe#dc33ae342ee8cea9

 

[kirkm]

What a cow of a problem!

I can't change the data and add an extra apostrophe.

Thanks for the link, sure is a mess and ticking the
Transition box didn't help.

I'll try changing every ' to a substitute character then
change that back when it's out of Excel. I was only using Excel for
ease of editing.

I can't quite believe Excel would eat a character and stuff you up
like this!

Thanks - Kirk