View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Graham S
 
Posts: n/a
Default Format numbers (ie 1st, 2nd, 3rd, 4th, 22nd, etc)

I have a column of numbers which are the result of determining the number of
years between two dates. I need to display a formatted results (ie: 1st,
2nd, 3rd, 4th, 22nd, etc.). Is there a way to do this?

Any suggestions would be appreciated.
--
Thanks,

Graham S