Text to Number
Try this:
Select the single-column range to be impacted
From the Excel main menu:
<data<text-to-columns
Click [Finish]
Does that help?
***********
Regards,
Ron
XL2002, WinXP
"Talladega" wrote:
Hi
I have a series of numbers in each row with an apostrophe in the front. How
do i create a formula that can take out the apostrophe, so the zero in the
front of the number disappear leaving only numbers.
ex: '014564 -- 14564
'077454 -- 77454
'023457 -- 23457
'077875 -- 77875
|