I have a column of numbers in ranges (30-44; 51-62). Is there a formula that
will automatically convert to numbers (30; 31; 32; etc.)?

go to tool-- autocorrect options-auto format as you type
and uncheck "Internet..."
"Newbee101" wrote in message
...
I have a column of numbers in ranges (30-44; 51-62). Is there a formula
that
will automatically convert to numbers (30; 31; 32; etc.)?

Sorry posted to a wrong question.

"N Harkawat" wrote in message
...
go to tool-- autocorrect options-auto format as you type
and uncheck "Internet..."
"Newbee101" wrote in message
...
I have a column of numbers in ranges (30-44; 51-62). Is there a formula
that
will automatically convert to numbers (30; 31; 32; etc.)?

Hi
you may try the following formula in cell B1:
=IF(LEFT($A1,FIND("-",$A1)-1)+COLUMN(A:A)-1<=--MID($A1,FIND("-",$A1)+1,
15),LEFT($A1,FIND("-",$A1)-1)+COLUMN(A:A)-1,"")
and copy to the right

But better to use VBA for this

--
Regards
Frank Kabel
Frankfurt, Germany

"Newbee101" schrieb im
Newsbeitrag ...
I have a column of numbers in ranges (30-44; 51-62). Is there a
formula that
will automatically convert to numbers (30; 31; 32; etc.)?