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
|