Hi,

It's not broken so it doesn't need fixing. The first apostrophe allows you
to display input as entered; leading zeroes for example, without having to
format as text and isn't displayed in the cell which is a very useful piece
of functionality.

It does have the side effect of you having to enter 2 apostrophes if you
want to see 1 but most would accept this is no big deal.

Mike

"kirkm" wrote:


I refer to a leading apostrophe in a text (or possibly any) cell. In
order to have one, you need two. Yes I know it's crazy but it's true!

There's no way to fix this, I suppose ?

Thanks - Kirk