Excel column format problem, please help

[RandyM]

I use a billing number in column "A" that always starts with
22-number. I get tired of repeating the 22- before every number. I wan
to be able to type in the last four numbers and have the 22- pop i
thier automatically, is that possible and if so, can some one tell m
how to do it?

Thank you in advance,

Randy:confused

 

[Greg Koppel]

Format Cells, Number tab, Custom from the list, type 22-# in the box

HTH, Greg

 

[Judi]

Select the range, (Click and drage the column that you are
going to enter these numbers in.)
Click Format on the menubar, Click cell.
Under Category, Click Custom
Under Type:
Type 22-#### (The number of "#" should be the same number
of numbers that you use)
Click OK

Hope this helps
Judi