I forgot:
After you got the correct numeric values, you can switch back to your
normal locale setting. As already outlined, this has no effect on
existing data.
Instead of the global application locale you may also set the cells'
number format locale before you start the search&replace operation.
Format>Cells...tab:Numbers, right side number format locale
Choose number format "@" (Text) when you need to convert numbers to
text. This special number format inhibits all evaluation even without
the leading apostrophe.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
