Excel column format problem, please help

R

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
 
G

Greg Koppel

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

HTH, Greg
 
J

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
 
Top