View Single Post
  #2   Report Post  
Marvin P. Winterbottom
 
Posts: n/a
Default

=mid(a1,3,2) will pick out those 2 characters

"PhilGTI" wrote:

I have a column with a long number, similar to a VIN number on a car.
I need to be able to display only the 3rd and 4th digits, which represent
the year.
Example:

3692040105 (year is 1992)
3694789321 (year is 1994)
3795564113 (year is 1995)

I want this column to look like-
92
94
95

Is this possible? Is there a formula or a custom formating I can use?