Thread: Date Format
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
leung747 leung747 is offline
external usenet poster
 
Posts: 4
Default Date Format

I have created a Userform to accept a date input (8 characters) in the form
of mm/dd/yy. When the data is transferred to the spreadsheet, the display
show mm/dd/yy but the content is changed to mm/dd/yyyy. I need the content
to stay at mm/dd/yy. Any suggestions?

Thanks!