View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default how can i change european date format to american

Format Cells... Custom m/d/yyyy
--
Gary's Student


"pclifford99" wrote:

I've been trying to convert my data format from day/month/year to
month/day/year. I have played with the custom feature, the date function,
etc...... i can't get excel to make the proper conversion and could use some
input.
--
phil