Thread: Formatting involving year
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Barb Reinhardt Barb Reinhardt is offline
external usenet poster
  
Posts: 3,355
Default Formatting involving year
Try something like this

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

--
HTH,
Barb Reinhardt



"allycat1186" wrote:

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?
Reply With QuoteReply With Quote