View Single Post
  #2   Report Post  
bj
 
Posts: n/a
Default

the simplest method would be to use a helper column (A:A)
fill it with 0.0 to whatever the highest number is
in your working column (B/)enter in B1
=text(A1,"0.0")&"-"&text(A2,"0,0")&"mm"
copy down as far as you need.
I would then coly the column and paste special values over the top of itself
and then delete the helper column.

"Bowbender" wrote:

Hello All,

Here is what I have to deal with.

I have around 1,200 labels that I don't want to have to type in. I
would like to us the fill down method. The labels will be as
follows...

0.0-0.1mm
0.1-0.2mm
0.2-0.3mm

and so on.

Keep in mind, they are labels and I am not actually subtracting them.
Doing that 1,200 times will not be fun. Help is appreciated.

Thanks,

Bowbender