Exporting to excel

Carol-Anne Cerbone

Hi

I have a sheet that has a date column that is set to MM/DD/YYYY but when I export the sheet to excel the date field is coming over as MM/DD/YY.

Is that suppose to happen? Am I doing something wrong?

Thanks

Carol-Anne

Purnima Gore_PGPS

No, it is probably what your spreadsheet date format is set to. Once you format the column with the date format you want, it will change it. Remember to look at the locale of your system. I find that even if I have set it to a UK format, sometimes that doesn't flow through to the other products and so I have to manually change it.

Carol-Anne Cerbone

@Purnima Gore_PGPS - Thanks for the insight.

Purnima Gore_PGPS

No, it is probably what your spreadsheet date format is set to. Once you format the column with the date format you want, it will change it. Remember to look at the locale of your system. I find that even if I have set it to a UK format, sometimes that doesn't flow through to the other products and so I have to manually change it.

Carol-Anne Cerbone

@Purnima Gore_PGPS - Thanks for the insight.