View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Yvonne Yvonne is offline
external usenet poster
 
Posts: 26
Default How do I abbreviate a year?

I am entering some data and need to abbreviate the year. Instead of 2009, I
need it to read '09, or '05, etc.

I have selected "treat as Text," but that doesn't work. I seem to remember
there was a way to do it, but for the life of me, I can't remember how.

I would appreciate it if anyone could help me out.