changing 4 digits into 2 digit year

  • Thread starter Thread starter frankg
  • Start date Start date
F

frankg

I have a cell with 2003 as a number and I want another cell to copy it
as 03. Inotherwords I enter 2003 in one cell and and I want it copied
to another cell as 03 (to represent a 2 digit year). Seems simple but
I'm going brain dead today so I'm having trouble. I'd like to do this
without macros or vba.

Excel advice please
 
Frankg, here is one way with 2003 in A1 =RIGHT(A1,2)

--
Paul B
Always backup your data before trying something new
Using Excel 97 & 2000
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **
 
I have a cell with 2003 as a number and I want another cell to copy it
as 03. Inotherwords I enter 2003 in one cell and and I want it copied
to another cell as 03 (to represent a 2 digit year). Seems simple but
I'm going brain dead today so I'm having trouble. I'd like to do this
without macros or vba.

Excel advice please
Click to expand...


If your four digit number is in A1,

=MOD(A1,100)

will give the last two digits. (Actually, it will give the digits in the
rightmost two places, regardless of the length of the number).

Custom format as 00


--ron
 
If you enter 2003 in cell B1 , put this in cell C1:
=Right(B1,2) that will then display 03 in cell C1.
 
I have a cell with 2003 as a number and I want another cell to copy it
as 03. Inotherwords I enter 2003 in one cell and and I want it copied
to another cell as 03 (to represent a 2 digit year). Seems simple but
I'm going brain dead today so I'm having trouble. I'd like to do this
without macros or vba.

Excel advice please
Click to expand...


If your four digit number is in A1,

=MOD(A1,100)

will give the last two digits. (Actually, it will give the digits in the
rightmost two places, regardless of the length of the number).

Custom format as 00


--ron
 
Back
Top