How to arrange number?
Hi
Thank u for ur reply, when i pasted ur formula its showing a number like
this 9.66501E+11
i want the number without decimal value coz these are mobile numbers with
country code and could u pls tell me why it shows a number like
9.66501E+11(this)
--
Life isa journey not a destination
"Ms-Exl-Learner" wrote:
Assume that you are having the value in A1 cell like the below:-
A1 cell
0056 4 65
Paste the below formula in B1 cell
=VALUE(SUBSTITUTE(A1," ",""))
Change the cell reference to your desired cell, if required.
Remember to Click Yes, if this post helps!
--------------------
(Ms-Exl-Learner)
--------------------
"Sherees" wrote:
Hi
I have a column of around 2000 customer mobile numbers, the numbers are
having space in between nad some numbers entered with two zero in the front.
How can i arrange all the numbers without zero in front and without any space
in between? please guide me with the easiest method
Thank u
--
Life isa journey not a destination
|