One day, I will install 2003 <G

Bob

"Tom Ogilvy" wrote in message
...
Just for info, that didn't affect the visibility of a leading apostrophe
in
Excel 2003.

--
Regards,
Tom Ogilvy


"Bob Phillips" wrote in message
...
Check ToolsOptionsTransition, and see if the Transition navigation
keys
box is checked, if so, uncheck it.

--
HTH

Bob Phillips

"Ben" wrote in message
...
I am importing Excel data that has what seems to be blank cells but on
closer
inspection I can see an apostrphe in the formula bar. That's not a
problem
because I have written a macro to identify apostrophes and clear the
contents
of these cells.
The mystery is that when the same data is imported on a friend's
computer
with the same version of Excel the apostrophe does not appear in his
formula
bar (although they are still non-blank cells) and so my macro will not
work
on his computer since it doesn't see the apostrophes. Although I can
write
a
different macro in his case, I am interested to know what setting in
Excel
is
responsible for showing apostrophes in blank cells on some computers
but
not
others.

Thank you