Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can i change european date format to american
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can i change european date format to american
Perhaps your dates are text and not dates.
Try DataText to ColumnsNextNextColumn Data FormatDateMDY and Finish. Gord Dibben MS Excel MVP On Mon, 27 Nov 2006 16:05:01 -0800, pclifford99 wrote: 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can i change european date format to american
That did not work either. let me expalin in greater detail. i pulled some
data off a european website. i copy/pasted the data into my excel file. I suspect when i pasted it i was taking the european date format and pasting as the default u.s. format. could this be the issue ? i am about to start pulling my hair out ! thanks -- phil "Gord Dibben" wrote: Perhaps your dates are text and not dates. Try DataText to ColumnsNextNextColumn Data FormatDateMDY and Finish. Gord Dibben MS Excel MVP On Mon, 27 Nov 2006 16:05:01 -0800, pclifford99 wrote: 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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can i change european date format to american
Can i email this file to anyone to look at ?
-- phil "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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can i change european date format to american
Pasting will not change your default format. Also, pasting only stores a value,
it does not apply a format. Try typing in a date, and then applying the same format to it. If this works, it means the format you are using is correct, and therefore the problem is your dates are text, not dates. Text to columns will solve your problem, if used properly, but if you don't like that, try creating a helper column with the formula: =a1+0 That will force excel to convert the date to a serial number, and your format should work. -- Regards, Fred "pclifford99" wrote in message ... That did not work either. let me expalin in greater detail. i pulled some data off a european website. i copy/pasted the data into my excel file. I suspect when i pasted it i was taking the european date format and pasting as the default u.s. format. could this be the issue ? i am about to start pulling my hair out ! thanks -- phil "Gord Dibben" wrote: Perhaps your dates are text and not dates. Try DataText to ColumnsNextNextColumn Data FormatDateMDY and Finish. Gord Dibben MS Excel MVP On Mon, 27 Nov 2006 16:05:01 -0800, pclifford99 wrote: 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 |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can i change european date format to american
Send it my email.
Change the at and dot as needed. Gord On Mon, 27 Nov 2006 16:41:02 -0800, pclifford99 wrote: Can i email this file to anyone to look at ? Gord Dibben MS Excel MVP |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can i change european date format to american
there goes one clump is hair. i am confused by your solution so don't even
know where/how to start. -- phil "Fred Smith" wrote: Pasting will not change your default format. Also, pasting only stores a value, it does not apply a format. Try typing in a date, and then applying the same format to it. If this works, it means the format you are using is correct, and therefore the problem is your dates are text, not dates. Text to columns will solve your problem, if used properly, but if you don't like that, try creating a helper column with the formula: =a1+0 That will force excel to convert the date to a serial number, and your format should work. -- Regards, Fred "pclifford99" wrote in message ... That did not work either. let me expalin in greater detail. i pulled some data off a european website. i copy/pasted the data into my excel file. I suspect when i pasted it i was taking the european date format and pasting as the default u.s. format. could this be the issue ? i am about to start pulling my hair out ! thanks -- phil "Gord Dibben" wrote: Perhaps your dates are text and not dates. Try DataText to ColumnsNextNextColumn Data FormatDateMDY and Finish. Gord Dibben MS Excel MVP On Mon, 27 Nov 2006 16:05:01 -0800, pclifford99 wrote: 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 |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can i change european date format to american
If your dates are real, which I suspect is not the case, =ISNUMBER(cellref) wil
return TRUE. If not real....FALSE Gord On Mon, 27 Nov 2006 17:43:01 -0800, pclifford99 wrote: there goes one clump is hair. i am confused by your solution so don't even know where/how to start. Gord Dibben MS Excel MVP |
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can i change european date format to american
Got it, thanks. I went back and tried DMY. that convererted it to the format
i needed. I started with data listed as day/month/year so i am not sure why entering DMY would convert to (month/day/year). I'd be curious just to know and learn something. any idea ? thanks phil "Gord Dibben" wrote: Perhaps your dates are text and not dates. Try DataText to ColumnsNextNextColumn Data FormatDateMDY and Finish. Gord Dibben MS Excel MVP On Mon, 27 Nov 2006 16:05:01 -0800, pclifford99 wrote: 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 |
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can i change european date format to american
I never know which to try first so I try DMY and see what happens.
Then MDY or YMD or whatever. I think there is a system but I haven't found it yet. Gord On Mon, 27 Nov 2006 17:53:01 -0800, pclifford99 wrote: Got it, thanks. I went back and tried DMY. that convererted it to the format i needed. I started with data listed as day/month/year so i am not sure why entering DMY would convert to (month/day/year). I'd be curious just to know and learn something. any idea ? thanks phil "Gord Dibben" wrote: Perhaps your dates are text and not dates. Try DataText to ColumnsNextNextColumn Data FormatDateMDY and Finish. Gord Dibben MS Excel MVP On Mon, 27 Nov 2006 16:05:01 -0800, pclifford99 wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I change the date format in Excell from eg 20060926 | Excel Discussion (Misc queries) | |||
Can I change a date with no format (20051111) to date format? | New Users to Excel | |||
How change Excel default date format to something useful | Excel Discussion (Misc queries) | |||
How change the date format in the excel footer to dd mmm yy? | Excel Discussion (Misc queries) | |||
change date function format in footer | Excel Worksheet Functions |