Thread: customize date
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
enrico via OfficeKB.com enrico via OfficeKB.com is offline
external usenet poster
 
Posts: 9
Default customize date

i customized a cell with a now() date field so that it's date is always
updated. i also designed the cell and add a "th" word so that today would be
shown like this: 15th. what i miss is that the first to third day doesn't end
up with "th" but rather "st", "nd" and "rd" respectively. how will i
customize it that it will be flexible according to the date? (e.g. 1st, 2nd,
3rd, 4th, etc.)

--
Message posted via http://www.officekb.com