If you enter 2003 in cell B1 , put this in cell C1:
=Right(B1,2) that will then display 03 in cell C1.

"frankg" wrote in message
...
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