convert to number alert msg

[MNJ]

Hi,
May I know how to programically convert to number when my values are stored as text.

Many Thanks.

[stanleydgrom]

If your number formatted as text data is in cell A1, in cell B1 type in this formula =VALUE(A1)

If you have a column of numbers formatted as text data in column A, and column B is blank, you could highlight column A, click on Edit, Copy, and highlight column B, and click on Edit, Paste Special, in the 'Paste' area click on 'Values', and in the 'Operation' area click on 'Add', and then click on 'OK'.

Have a great day,
Stan

[Bob Phillips]

I think an example will help to clarify.

[excelliot]

I think he meann to say:

Cell A= "One Hundred"
Cell B= "=value(CellA)"

And result he want is 100