View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
 
Posts: 3,718
Default changing date format

Try this:

TEXT(A1,"yymmdd")


"Julie" wrote:

I have spreadsheets with dates I need to convert in order to send info. to
customer electronically.

Current spreadsheet shows 09/20/08 or September 20, 2008
Need it to show 080920 with no slashes

Can anybody help me?

--
Julie