adding a characters at the end of an equation.

**steven_c** · 08-30-2010, 02:46 PM

I am sure this is easy and I'm simply searching for the wrong thing. I want to auto fill a column numerically =+1 style. But, at the end of the number I would like there to be a -C. It would look like:
1000-C
1001-C
1002-C
....

Any help is greatly appreciated.

Thanks

**zbor** · 08-30-2010, 02:48 PM

You can format cell as 0"-C" and write just number in it

**steven_c** · 08-30-2010, 03:11 PM

Originally Posted by zbor

You can format cell as 0"-C" and write just number in it

I'm not quite sure what you mean. I don't want to write all the numbers in because I have over 5000 entries to label. I would really like to be able to use the autofill feature to do this.

**Richard Buttrey** · 08-30-2010, 03:20 PM

Hi,

All zbor is saying is once you've autofilled your column with numbers, 1001,1002 etc.. just select the whole column, and choose Format->Cells->Number choose Custom and in the custom format box enter 0"-C"

HTH

**rgi** · 08-30-2010, 03:36 PM

Alternatively, create your column of numbers then in a second column use the formula =Text(a1,"####0")&"-C". This will give you the result you want. The other approach only adds the -C to the format and not the value.