View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
pclifford99 pclifford99 is offline
external usenet poster
 
Posts: 6
Default how can i change european date format to american

for whatever reason, that does not work. i've tried it about a dozen times.
i've cut and pasted "values only" to other parts of my spreadsheet thinking
maybe the format was corrupted, but no go. any furthur ideas ?

thanks
--
phil


"Gary''s Student" wrote:

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