| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting involving year
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formatting involving year
Thank you!
"Barb Reinhardt" wrote: 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copyright Year Re-Formatting | Excel Worksheet Functions | |||
| condition formatting involving formula | Excel Worksheet Functions | |||
| Combination Graph with current year and prior year sales | Charts and Charting in Excel | |||
| Formula for Fiscal Year Conditional Formatting | Excel Discussion (Misc queries) | |||
| How to compare current year to prior year in bar chart? | Charts and Charting in Excel | |||
Linear Mode
