And if your entries are all numeric, you can change how they look (not the real
value) via:

Select the range
format|Cells|Number tab (in xl2003 menus)
Custom category
"A-"0000

The value will still be the numbers, but it'll look pretty.

Ty Archer wrote:

I have columns with four digits and wish to add two characters "A-" at the
beginning. For example 1123 will be replaced with "A-1123". How can I do
this? Thanks for your help.

--

Dave Peterson