Thread: DATE format!
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default DATE format!
=--TEXT(A1,"00\/00\/00")

Format cell as: m/dd/yy


"Barbara" wrote:

Hi,
How can I convert 80207 to 08/02/07 (date format)?

thanks,
Barbara

Reply With QuoteReply With Quote