Thread: Date Seperator
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Date Seperator

Hi,

If it's already a properly formatted date then applying a custom format of
YYYYMMDD should do what you require.

Mike

"burt" wrote:

I have a date in the YYYY-MM-DD format I need to display it as YYYYMMDD with
no seperators ie / or -

Any help much apreciated