Formatting involving year

allycat1186 · Oct 13, 2007

In a column I have a current setup of "yy-#####" (ex: 96-12345) I want
"Ryyyy-#####"(ex: R1996-12345). Also, I have data from 1990-current. Any
tips?

Barb Reinhardt · Oct 13, 2007

Try something like this

="R" & IF(VALUE(LEFT(A1,2))<=7,"20","19")& A1

allycat1186 · Oct 13, 2007

Thank you!

Barb Reinhardt said:
Try something like this

="R" & IF(VALUE(LEFT(A1,2))<=7,"20","19")& A1