View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Remove slash charaters from a date field

You could have kept the dates in the cells as dates, and used a custom
number format that omits any punctuation. For example, "yyyymmdd" or
"mmddyy". This would be more useful if you needed the numeric character of
the dates.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"GaryO" wrote in message
...
How do I remove the slash characters from a date field. I have converted
all
the date formats to text and need a way to remove the slashes.