Hi Gert, > How do I convert a range of alpha cell contents (i.e. a numeric value > preceded by ' (single quote)) to numerics.
Use the formula "=VALUE(A1)" to get the numeric value of cell A1. You can copy this formula so you have a list of all the values yopu need. Copy the values and "Past Special" them into the original cells. Make sure that the selection for "formula" is turned of! With regards, Jeroen --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
