Title: Date format
Last modified: August 21, 2016

---

# Date format

 *  Resolved [areality](https://wordpress.org/support/users/areality/)
 * (@areality)
 * [12 years, 5 months ago](https://wordpress.org/support/topic/date-format-28/)
 * Hi,
 * Is there a way to make Visualizer understand European date formatting (i.e. dd/
   mm/yyyy) in the Google Spreadsheets?
 * I have data series in Google Spreadsheets that would return an empty Vizualizer
   chart if I set an european locale in the Google Spreadsheet settings. Here is
   an example:
 * date number number
    24.12.2013 567.67 1098.64 17.12.2013 554.99 1091.66 13.12.2013
   554.43 1088.78 06.12.2013 560.02 1082.9 29.11.2013 556.07 1078.1 22.11.2013 519.8
   1072.73
 * When I change locale to the US in the Google Spreadsheets, data appears on Visualizer
   charts without any problem. Here is the same data with US Locale settings.
 * date number number
    12/24/2013 567.67 1098.64 12/17/2013 554.99 1091.66 12/13/
   2013 554.43 1088.78 12/6/2013 560.02 1082.9 11/29/2013 556.07 1078.1 11/22/2013
   519.8 1072.73
 * Any quick move to feed Visualizer with Eurpopean-style dates?
    Thanks!
 * [http://wordpress.org/plugins/visualizer/](http://wordpress.org/plugins/visualizer/)

Viewing 1 replies (of 1 total)

 *  [lleo](https://wordpress.org/support/users/lleo/)
 * (@lleo)
 * [11 years, 9 months ago](https://wordpress.org/support/topic/date-format-28/#post-4450076)
 * Hello,
 * It’s been a long time since it was posted but it can still be helpful to others.
 * I’m new around here, and I’m not sure if Visualizer can switch
    But I thought
   in a way around this: I would open your spreadsheet in excel and let it do all
   the conversion work for you. And then just copy the format that we know visualizer
   will accept.
 * Here’s how to do it in excel:
    [http://www.extendoffice.com/documents/excel/585-excel-change-american-date-format.html](http://www.extendoffice.com/documents/excel/585-excel-change-american-date-format.html)
 * All the Best

Viewing 1 replies (of 1 total)

The topic ‘Date format’ is closed to new replies.

 * ![](https://ps.w.org/visualizer/assets/icon-256x256.gif?rev=3084574)
 * [Visualizer: Tables and Charts Manager for WordPress](https://wordpress.org/plugins/visualizer/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/visualizer/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/visualizer/)
 * [Active Topics](https://wordpress.org/support/plugin/visualizer/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/visualizer/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/visualizer/reviews/)

 * 1 reply
 * 2 participants
 * Last reply from: [lleo](https://wordpress.org/support/users/lleo/)
 * Last activity: [11 years, 9 months ago](https://wordpress.org/support/topic/date-format-28/#post-4450076)
 * Status: resolved