MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Form "3" to 3


Posted by Noo on September 16, 2001 7:40 AM

in A1 has text "3"
in A2, I need to link from A1 and get number 3 in stead of text "3".
What should I do?
Thanks


Posted by Aladin Akyurek on September 16, 2001 8:01 AM

It all depends on what you mean by "linking".

If you want just convert A1 to number, enter 1 in an empty cell, do a copy while there, select A1, activate Edit|Paste Special, choose multiply. This will convert the value in A1 to number. Delete 1.

Or

in A2 enter: =A1+0

If you have a formula in A2 which uses A1, A1+0 as part of the formula would work.

Still in doubt, post the formula that you (intend to) have in A2.

Aladin


Posted by Noo on September 16, 2001 11:28 PM

="3" vs "3" without equal sign

There are 2 cases:

Case1:
If A1 enter ="3"
in A2 enter: =A1+0
It shows 3

Case 2:
If A1 enter "3" or "3 (Without equal sign)
in A2 enter: =A1+0
It shows #Value! Error


My case is case 2, please helps.

Posted by Aladin Akyurek on September 17, 2001 12:22 AM

3 between double quotes (Re: ="3" vs "3" without equal sign)

If you enter numbers between double quotes, not preceeded by an =-sign, use

=SUBSTITUTE(A1,CHAR(34),"")+0

Aladin

======================