Thread: Formatting Date
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
newguy newguy is offline
external usenet poster
 
Posts: 19
Default Formatting Date

I have a column that contains dates in this format mm/dd/yyyy. I need
mmddyyyy no slashs. If I do a custom format it still shows mm/dd/yyyy in the
the fx bar. I have tried using vbscipt replace method and copy the new date
to a different column but it drops the zeros no matter what the columns
format is. I need to create passwords from this column and I have to take out
the slashes.