The extension by  Cor Nouws, CT2N, "Convert Text 2 Numbers" is ideal and
Paste, then click on the icon in the toolbar and it is done.
Wherever there is a number prefixed by ' the ' will be removed.
Nothing else will be changed and your sheet looks exactly the same.
Here is the link

View this message in context:
Sent from the Users mailing list archive at

For unsubscribe instructions e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted

Reply via email to