Find & Replace (Adding two characters at begining)
Thanks Jim,
That work great.
"Jim Thomlinson" wrote:
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.
|