Data fill question
 

Hi all,
How do I do an auto fill on a certain amount of cells in a range of numbers
but at the end of the number there is a dash s. For example: 343-s,
344-s,345-s and so on. I tried to do the auto fill but it is just repeating
the sequence of numbers?

You could use a formula. With the first cell filled in
(like A1), put this in A2 and fill down:

=(LEFT(A1,FIND("-",A1)-1)+1)&"-s"

HTH
Jason
Atlanta, GA

-----Original Message-----
Hi all,
How do I do an auto fill on a certain amount of cells in
a range of numbers
but at the end of the number there is a dash s. For
example: 343-s,
344-s,345-s and so on. I tried to do the auto fill but
it is just repeating
the sequence of numbers?
.

Erin

Would a custom format work for you?

FormatCellsNumberCustom type in ###0"-s"


Gord Dibben Excel MVP

On Thu, 31 Mar 2005 13:11:01 -0800, "Erin"
wrote:

Hi all,
How do I do an auto fill on a certain amount of cells in a range of numbers
but at the end of the number there is a dash s. For example: 343-s,
344-s,345-s and so on. I tried to do the auto fill but it is just repeating
the sequence of numbers?