Thread: date format
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips Bob Phillips is offline
external usenet poster
  
Posts: 380
Default date format
If it is a string, then

=SUBSTITUTE(A1,"/","")

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"EdJack" wrote in message
...
How do I change "2006/10/02" to "20061002"


Reply With QuoteReply With Quote