How do I format 10-12 to appear as 10; 11; 12?

N

Newbee101

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.)?
 
N

N Harkawat

go to tool--> autocorrect options->auto format as you type
and uncheck "Internet..."
 
F

Frank Kabel

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
 
Top