View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
frankg frankg is offline
external usenet poster
 
Posts: 6
Default changing 4 digits into 2 digit year

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