Couldn't tell ya.. I have not used apostrophes since I left Lotus many years
ago...
--
HTH...

Jim Thomlinson


"Josh Sale" wrote:

Thanks Jim.

But if its not a format, why does Edit | Paste Special | Format seem to do
different things depending on if the source and target cells have a leading
apostrophe?

josh



"Jim Thomlinson" wrote in message
...
It is there for compatibility with Lotus 123. It is not truely a format.
It
is an indicator that the value in the cell is not numeric and is not
subject
to calculation. That is all it means. It does not change the format of the
cell. It does not change anything about the cell. Lotus does not require
the
= sign to indicate a formula. So if you wanted a cell to show 2 + 3 then
you
needed to type it in '2 + 3 otherwise it would display the 5...
--
HTH...

Jim Thomlinson