View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ryguy7272 ryguy7272 is offline
external usenet poster
 
Posts: 2,836
Default changing date format

Right-click on cell, Format Cells Custom Type = yymmdd

Regards,
Ryan--

--
RyGuy


"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