{"id":3078,"date":"2015-12-09T13:23:43","date_gmt":"2015-12-09T13:23:43","guid":{"rendered":"http:\/\/www.price2spy.com\/blog\/?p=3078"},"modified":"2016-06-28T13:36:43","modified_gmt":"2016-06-28T13:36:43","slug":"new-number-format-setting-available-in-price2spy","status":"publish","type":"post","link":"https:\/\/www.price2spy.com\/blog\/new-number-format-setting-available-in-price2spy\/","title":{"rendered":"New number format setting available in Price2Spy!"},"content":{"rendered":"
Over the course of time, Price2Spy has gained clients from different parts of the world using different regional settings.<\/div>\n

<\/p>\n

For example, in certain countries . (dot) may be used for a decimal separator, while in others it may be , (comma).<\/div>\n

<\/p>\n

Although MS Excel should be smart enough to recognize that difference on the fly, and convert it to your desired local format (as defined in your Computer’s Regional Settings), it may not work just like that out of the box.<\/div>\n

<\/p>\n

In order to prevent such problems, we have come up with 6 different number format settings.<\/div>\n

<\/p>\n

Please experiment with these in order to find the setting which will fit your regional settings best.<\/div>\n

<\/p>\n

The selected number format will be reflected both in the browser and in the Excel files you export from Price2Spy. However, this change will not affect the data that Price2Spy sends via API.<\/div>\n

<\/p>\n

If you go to Settings => Account settings<\/strong> there is a Number format<\/strong> dropdown menu where you can see the default and change your number format settings.<\/div>\n
\n
\n
\n
\"1\"<\/a><\/div>\n
<\/div>\n
And now, let’s see the other options!<\/div>\n
\"2\"<\/a><\/div>\n
<\/div>\n
1)<\/b>\u00a0This is how the\u00a0Price Matrix report<\/b>\u00a0looks like in browser after changing the format – we chose the 4th option highlighted in the previous picture.<\/div>\n
\"3\"<\/a><\/div>\n
<\/div>\n
The Excel file corresponds as well:<\/div>\n
\"4\"<\/a><\/div>\n
<\/div>\n
2)\u00a0<\/b><\/span>This is the\u00a0Price Matrix report<\/b>\u00a0in browser with the 5th option chosen:<\/div>\n
\"5\"<\/a><\/div>\n
<\/div>\n
And the corresponding Excel:<\/div>\n
\"6\"<\/a><\/div>\n<\/div>\n<\/div>\n
<\/div>\n
\n
Important: if you’re unsure which setting is the right fit for you – please make sure to use the DEFAULT SETTING ON<\/b>.<\/div>\n

<\/p>\n

We do our best to respond to our clients’ suggestions and needs, and we hope that you will find this new feature useful!<\/div>\n

<\/p>\n

If you have any problems with the number formatting, please let us know and send us a screenshot of the Excel file you opened on your PC and a screenshot of your Settings page in your Price2Spy account.<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

Over the course of time, Price2Spy has gained clients from different parts of the world using different regional settings. For example, in certain countries . (dot) may be used for a decimal separator, while in others it may be , (comma). Although MS Excel should…<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[167],"tags":[],"class_list":["post-3078","post","type-post","status-publish","format-standard","hentry","category-new-price2spy-features"],"yoast_head":"\nNew number format setting available in Price2Spy! - Price2Spy\u00ae Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.price2spy.com\/blog\/new-number-format-setting-available-in-price2spy\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"New number format setting available in Price2Spy! - Price2Spy\u00ae Blog\" \/>\n<meta property=\"og:description\" content=\"Over the course of time, Price2Spy has gained clients from different parts of the world using different regional settings. For example, in certain countries . (dot) may be used for a decimal separator, while in others it may be , (comma). Although MS Excel should...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.price2spy.com\/blog\/new-number-format-setting-available-in-price2spy\/\" \/>\n<meta property=\"og:site_name\" content=\"Price2Spy\u00ae Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/Price2Spy\/\" \/>\n<meta property=\"article:published_time\" content=\"2015-12-09T13:23:43+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2016-06-28T13:36:43+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.price2spy.com\/blog\/wp-content\/uploads\/2015\/12\/1.png\" \/>\n<meta name=\"author\" content=\"Maja\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@Price2Spy\" \/>\n<meta name=\"twitter:site\" content=\"@Price2Spy\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Maja\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"New number format setting available in Price2Spy! - Price2Spy\u00ae Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.price2spy.com\/blog\/new-number-format-setting-available-in-price2spy\/","og_locale":"en_US","og_type":"article","og_title":"New number format setting available in Price2Spy! - Price2Spy\u00ae Blog","og_description":"Over the course of time, Price2Spy has gained clients from different parts of the world using different regional settings. For example, in certain countries . (dot) may be used for a decimal separator, while in others it may be , (comma). Although MS Excel should...","og_url":"https:\/\/www.price2spy.com\/blog\/new-number-format-setting-available-in-price2spy\/","og_site_name":"Price2Spy\u00ae Blog","article_publisher":"https:\/\/www.facebook.com\/Price2Spy\/","article_published_time":"2015-12-09T13:23:43+00:00","article_modified_time":"2016-06-28T13:36:43+00:00","og_image":[{"url":"https:\/\/www.price2spy.com\/blog\/wp-content\/uploads\/2015\/12\/1.png","type":"","width":"","height":""}],"author":"Maja","twitter_card":"summary_large_image","twitter_creator":"@Price2Spy","twitter_site":"@Price2Spy","twitter_misc":{"Written by":"Maja","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.price2spy.com\/blog\/new-number-format-setting-available-in-price2spy\/#article","isPartOf":{"@id":"https:\/\/www.price2spy.com\/blog\/new-number-format-setting-available-in-price2spy\/"},"author":{"name":"Maja","@id":"https:\/\/www.price2spy.com\/blog\/#\/schema\/person\/41d092bc2a20b7c2207c01c9f3dd4760"},"headline":"New number format setting available in Price2Spy!","datePublished":"2015-12-09T13:23:43+00:00","dateModified":"2016-06-28T13:36:43+00:00","mainEntityOfPage":{"@id":"https:\/\/www.price2spy.com\/blog\/new-number-format-setting-available-in-price2spy\/"},"wordCount":325,"commentCount":0,"image":{"@id":"https:\/\/www.price2spy.com\/blog\/new-number-format-setting-available-in-price2spy\/#primaryimage"},"thumbnailUrl":"https:\/\/www.price2spy.com\/blog\/wp-content\/uploads\/2015\/12\/1.png","articleSection":["New Price2Spy features"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.price2spy.com\/blog\/new-number-format-setting-available-in-price2spy\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.price2spy.com\/blog\/new-number-format-setting-available-in-price2spy\/","url":"https:\/\/www.price2spy.com\/blog\/new-number-format-setting-available-in-price2spy\/","name":"New number format setting available in Price2Spy! - Price2Spy\u00ae Blog","isPartOf":{"@id":"https:\/\/www.price2spy.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.price2spy.com\/blog\/new-number-format-setting-available-in-price2spy\/#primaryimage"},"image":{"@id":"https:\/\/www.price2spy.com\/blog\/new-number-format-setting-available-in-price2spy\/#primaryimage"},"thumbnailUrl":"https:\/\/www.price2spy.com\/blog\/wp-content\/uploads\/2015\/12\/1.png","datePublished":"2015-12-09T13:23:43+00:00","dateModified":"2016-06-28T13:36:43+00:00","author":{"@id":"https:\/\/www.price2spy.com\/blog\/#\/schema\/person\/41d092bc2a20b7c2207c01c9f3dd4760"},"breadcrumb":{"@id":"https:\/\/www.price2spy.com\/blog\/new-number-format-setting-available-in-price2spy\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.price2spy.com\/blog\/new-number-format-setting-available-in-price2spy\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.price2spy.com\/blog\/new-number-format-setting-available-in-price2spy\/#primaryimage","url":"https:\/\/www.price2spy.com\/blog\/wp-content\/uploads\/2015\/12\/1.png","contentUrl":"https:\/\/www.price2spy.com\/blog\/wp-content\/uploads\/2015\/12\/1.png","width":1165,"height":512},{"@type":"BreadcrumbList","@id":"https:\/\/www.price2spy.com\/blog\/new-number-format-setting-available-in-price2spy\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.price2spy.com\/blog\/"},{"@type":"ListItem","position":2,"name":"New number format setting available in Price2Spy!"}]},{"@type":"WebSite","@id":"https:\/\/www.price2spy.com\/blog\/#website","url":"https:\/\/www.price2spy.com\/blog\/","name":"Price2Spy\u00ae Blog","description":"Price2Spy\u00ae","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.price2spy.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.price2spy.com\/blog\/#\/schema\/person\/41d092bc2a20b7c2207c01c9f3dd4760","name":"Maja","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/e0047c8aa991b86af41fb85097b0466414c5dc40250014c08e00862c366caca5?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/e0047c8aa991b86af41fb85097b0466414c5dc40250014c08e00862c366caca5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/e0047c8aa991b86af41fb85097b0466414c5dc40250014c08e00862c366caca5?s=96&d=mm&r=g","caption":"Maja"},"url":"https:\/\/www.price2spy.com\/blog\/author\/m-rajic\/"}]}},"_links":{"self":[{"href":"https:\/\/www.price2spy.com\/blog\/wp-json\/wp\/v2\/posts\/3078","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.price2spy.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.price2spy.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.price2spy.com\/blog\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.price2spy.com\/blog\/wp-json\/wp\/v2\/comments?post=3078"}],"version-history":[{"count":28,"href":"https:\/\/www.price2spy.com\/blog\/wp-json\/wp\/v2\/posts\/3078\/revisions"}],"predecessor-version":[{"id":3112,"href":"https:\/\/www.price2spy.com\/blog\/wp-json\/wp\/v2\/posts\/3078\/revisions\/3112"}],"wp:attachment":[{"href":"https:\/\/www.price2spy.com\/blog\/wp-json\/wp\/v2\/media?parent=3078"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.price2spy.com\/blog\/wp-json\/wp\/v2\/categories?post=3078"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.price2spy.com\/blog\/wp-json\/wp\/v2\/tags?post=3078"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}