If value started with specific number, insert number before value

[jellevansoelen]

Hi Guys,

I'm looking for a script. A script when a cell starts with a specific number than insert two numbers before that number.
I have the following excel cells:

Book1
	A
1	2009/27
2	1988/14
3	96/97
4	2007/270
5	1986/2
6	1998/53
7	1988/83
8	92/70
9	1989/123
10	93/24
Sheet1

Now i want that IF the cell starts with a 9, thain insert two numbers (19) before the 9. Like 98 -> 1998

So the Excel file would be:

Book1
	A
1	2009/27
2	1988/14
3	1996/97
4	2007/270
5	1986/2
6	1998/53
7	1988/83
8	1992/70
9	1989/123
10	1993/24
Sheet1

Hopefully someone can help me.
Tnx!
Jelle

 

[arthurbr]

Like

=IF(left(a1,1)="9",19&a1,a1)

?

 

[jellevansoelen]

Like

=IF(left(a1,1)="9",19&a1,a1)

?

Perfect. Only thing is that I must use ; instead of ,

Tnx for your help!

 

[arthurbr]

You're welcome.