Two possible ways. One is to use a formula to ge tthe new value

="A-" & text(A1, "0000")
where your value is in cell a1

The other is to just format the cell. This does not change the value of the
cell only how it looks...

Format - Cells... | Number | Custom
"A-"0000
--
HTH...

Jim Thomlinson


"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.