Inserting text infront of numbers

[aashrestha]

Yesterday I got the solution to insert the text by using custom format. Exampe: 112233 to Ab-112233 by using "Ab-"General


But when I tried the same method to inserset the Ab on 11-1122

Like 11-1122 into Ab-11-1122 in same cell, it doesn't work

Please help me again

[windknife]

A1 =11-1122
b1 ="ab-" & a1

[aashrestha]

A1 =11-1122
b1 ="ab-" & a1

Actually I want on the same cell.

[aashrestha]

Please help me!!!

[JONvdHeyden]

You're bumping your post after as little as 6 minutes? Please be a little more patient.

Try the following format:

"ab-"@

[mubashir aziz]

Try this in custom format

"ab-" 0

[aashrestha]

You're bumping your post after as little as 6 minutes? Please be a little more patient.

Try the following format:

"ab-"@

Thank You Sir