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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

help with Sum in between dates 12
How can the font and size of (all) citation numbers be altered? 1
Excel does not accept text format! 0
get a list of sequence number that meet 3 criteria 0
customize count/sum formula for overdue dates 5
max function with conditional statment 5
problem with time subtraction 7
IF ARRAY with multiple conditions. 1

Top