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 **

"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