Thread: Make all dates display 01 as the day
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
LovingLife28 LovingLife28 is offline
external usenet poster
  
Posts: 3
Default Make all dates display 01 as the day
I have a list of dates with various numbers listed as the day (03/25/2009,
04/05/2010, etc.) I need a formula to change all of the dates to display 01
as the day (03/01/2009, 04/01/2010, etc). Thanks!
--
LL28
Reply With QuoteReply With Quote