Adding 2 numbers before the number

Question

Hi,

I need to add 91 before 10 digit numbers, for ex. 9988806636 becomes 919988806636. Please assist with a formula.

Also, is there any formula that could change the numbers stored as text into original numbers, for ex. 919971022591, when converted into number, turns into 9.19971E+11. I also tried to format the cell as "Number", however no luck.

Please suggest...

Thanks...

Answer 1

Hi, to add 91 to a number assuming the numbers are in column A in B enter

="91"&A2

copy formula down

to your 2nd question you see the # in the formula but it cannot be displayed as a number the maximum are 11 digits then will show as scientific notation

Answer 2

Hi,

I need to add 91 before 10 digit numbers, for ex. 9988806636 becomes 919988806636. Please assist with a formula.

Also, is there any formula that could change the numbers stored as text into original numbers, for ex. 919971022591, when converted into number, turns into 9.19971E+11. I also tried to format the cell as "Number", however no luck.

Please suggest...

Thanks...

To get rid of 9.111111+11   Custom format as  0

Gord

Answer 3

Hi,

Your first question has been answered below.  For the second question, just format the cell as Number and remove the 2 decimal places.

Hope this helps.

Answer 4

Here's a general formula:

=91*POWER(10,CEILING(LOG10(A1),1))+A1

If your 9988... is a string, the math above turned it into a number.

The general idea is   91* (10^10) + n.

= = = = =

HTH  :>)

Answer 5

With a value in A1, in another cell enter:

="91" & A1

To convert texts into genuine numbers, select them and run this tiny macro:

Sub dural()

    For Each r In Selection

        t = r.Text

        r.Clear

        r.Value = t

    Next r

End Sub