View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Albert Albert is offline
external usenet poster
 
Posts: 203
Default Convert European Date format to American Format

I work for an international company and when I download reports to excell or
access the dates and $$ come in European format, How can I reformat to
american? 24/8/2007 to 8/24/2007? and 1.000,00 to 1,000.00. Thanks!