[Skip to main content](#vessel-content) # Prices in CSV ## - **[tkult120](/forum/user/78462-tkult120 "View tkult120's Profile")** - [![tkult120's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/78462-tkult120 "View tkult120's Profile") Topic Author - [ Offline](/forum/user/78462-tkult120) Less More - Posts: 36 - Thank you received: 3 - - 10 months 1 week ago [\#369812](#369812) by [tkult120](/forum/user/78462-tkult120 "View tkult120's Profile") *[Prices in CSV](/forum/37-import-export-csv-xls/909989-prices-in-csv#369812 "-- url of the page with the problem -- : metalearth.shop -- HikaShop version -- : 6.1.1 -- Joomla version -- : 5.4.0 -- PHP version -- : 8.2 -- Browser(s) name and version -- : firefox Hello, I want to change prices of products in my shop. So, I export to .CSV file, opened in EXCEL. Then prices are given in format "Standard" and e.g. like 14.99 (numbers with a DOT). When I change the price in this CSV-file the format is changed, e.g. "14.99" I want to change in "9.99" but what appears is "346094" ???? How can I solve this problem ? Thanks for help- Rolf")* was created by *[tkult120](/forum/user/78462-tkult120 "View tkult120's Profile")* -- url of the page with the problem -- : [ metalearth.shop](http://metalearth.shop) -- HikaShop version -- : 6.1.1 -- Joomla version -- : 5.4.0 -- PHP version -- : 8.2 -- Browser(s) name and version -- : firefox Hello, I want to change prices of products in my shop. So, I export to .CSV file, opened in EXCEL. Then prices are given in format "Standard" and e.g. like 14.99 (numbers with a DOT). When I change the price in this CSV-file the format is changed, e.g. "14.99" I want to change in "9.99" but what appears is "346094" ???? How can I solve this problem ? Thanks for help- Rolf Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy85MDk5ODktcHJpY2VzLWluLWNzdj90bXBsPW1hcmtkb3du) or [Create an account](/register) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86324 - Thank you received: 14286 - - 10 months 1 week ago [\#369815](#369815) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Prices in CSV](/forum/37-import-export-csv-xls/909989-prices-in-csv#369815 "-- url of the page with the problem -- : metalearth.shop -- HikaShop version -- : 6.1.1 -- Joomla version -- : 5.4.0 -- PHP version -- : 8.2 -- Browser(s) name and version -- : firefox Hello, I want to change prices of products in my shop. So, I export to .CSV file, opened in EXCEL. Then prices are given in format "Standard" and e.g. like 14.99 (numbers with a DOT). When I change the price in this CSV-file the format is changed, e.g. "14.99" I want to change in "9.99" but what appears is "346094" ???? How can I solve this problem ? Thanks for help- Rolf")* Hi, I'm sorry but I'm not sure I understand the issue you have. Are you saying that your problem is that when you try to change 14.99 to 9.99 in the CSV, Excel changes the value of the cell to 646094 ? I've never heard about this and I don't know how we could help if the problem is in Excel. Or maybe I didn't understand what you mean ? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy85MDk5ODktcHJpY2VzLWluLWNzdj90bXBsPW1hcmtkb3du) or [Create an account](/register) to join the conversation. - **[tkult120](/forum/user/78462-tkult120 "View tkult120's Profile")** - [![tkult120's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/78462-tkult120 "View tkult120's Profile") Topic Author - [ Offline](/forum/user/78462-tkult120) Less More - Posts: 36 - Thank you received: 3 - - 10 months 1 week ago [\#369831](#369831) by [tkult120](/forum/user/78462-tkult120 "View tkult120's Profile") Replied by *[tkult120](/forum/user/78462-tkult120 "View tkult120's Profile")* on topic *[Prices in CSV](/forum/37-import-export-csv-xls/909989-prices-in-csv#369831 "-- url of the page with the problem -- : metalearth.shop -- HikaShop version -- : 6.1.1 -- Joomla version -- : 5.4.0 -- PHP version -- : 8.2 -- Browser(s) name and version -- : firefox Hello, I want to change prices of products in my shop. So, I export to .CSV file, opened in EXCEL. Then prices are given in format "Standard" and e.g. like 14.99 (numbers with a DOT). When I change the price in this CSV-file the format is changed, e.g. "14.99" I want to change in "9.99" but what appears is "346094" ???? How can I solve this problem ? Thanks for help- Rolf")* Hi Nicolas, YES - you did understand right, the correct value is "36404,00". My desired input "9.99" is changed by EXCEL if default format is set to "Number". I tried several times Export/Import, but the exported price-format "14.99" - can not be changed to "9.99" this will result in "Sep 99" , even when I try all formatting styles of Excel - can only changed to a format with comma , e.g. "9,99" or with two digits BEFORE the point , e.g. "16.99" I found in other forums that this is a default/preset in Excel to change formats to a date. For me the result is that I can only make a input in form of "9,99" if I have one digit before decimal-divider and I have to make a COMMA instead a POINT. Some other info? Enjoy Christmas and take your time for response. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy85MDk5ODktcHJpY2VzLWluLWNzdj90bXBsPW1hcmtkb3du) or [Create an account](/register) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86324 - Thank you received: 14286 - - 10 months 1 week ago [\#369832](#369832) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Prices in CSV](/forum/37-import-export-csv-xls/909989-prices-in-csv#369832 "-- url of the page with the problem -- : metalearth.shop -- HikaShop version -- : 6.1.1 -- Joomla version -- : 5.4.0 -- PHP version -- : 8.2 -- Browser(s) name and version -- : firefox Hello, I want to change prices of products in my shop. So, I export to .CSV file, opened in EXCEL. Then prices are given in format "Standard" and e.g. like 14.99 (numbers with a DOT). When I change the price in this CSV-file the format is changed, e.g. "14.99" I want to change in "9.99" but what appears is "346094" ???? How can I solve this problem ? Thanks for help- Rolf")* Hi, Note that in the HikaShop configuration, you have a setting "CSV decimal separator" where you can select between dot and comma. So if you need to have commas as separators for decimals for Excel to work properly, you can change it there. [ www.hikashop.com/support/documentation/5...nfig.html#main\_files](https://www.hikashop.com/support/documentation/54-hikashop-config.html#main_files) The following user(s) said Thank You: [tkult120](/forum/user/78462-tkult120 "View tkult120's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy85MDk5ODktcHJpY2VzLWluLWNzdj90bXBsPW1hcmtkb3du) or [Create an account](/register) to join the conversation. - **[tkult120](/forum/user/78462-tkult120 "View tkult120's Profile")** - [![tkult120's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/78462-tkult120 "View tkult120's Profile") Topic Author - [ Offline](/forum/user/78462-tkult120) Less More - Posts: 36 - Thank you received: 3 - - 10 months 3 days ago [\#369895](#369895) by [tkult120](/forum/user/78462-tkult120 "View tkult120's Profile") Replied by *[tkult120](/forum/user/78462-tkult120 "View tkult120's Profile")* on topic *[Prices in CSV](/forum/37-import-export-csv-xls/909989-prices-in-csv#369895 "-- url of the page with the problem -- : metalearth.shop -- HikaShop version -- : 6.1.1 -- Joomla version -- : 5.4.0 -- PHP version -- : 8.2 -- Browser(s) name and version -- : firefox Hello, I want to change prices of products in my shop. So, I export to .CSV file, opened in EXCEL. Then prices are given in format "Standard" and e.g. like 14.99 (numbers with a DOT). When I change the price in this CSV-file the format is changed, e.g. "14.99" I want to change in "9.99" but what appears is "346094" ???? How can I solve this problem ? Thanks for help- Rolf")* Hi , all the best for you and the staff in 2026. Will check the COMMA/POINT issue . Best regards Rolf The following user(s) said Thank You: [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy85MDk5ODktcHJpY2VzLWluLWNzdj90bXBsPW1hcmtkb3du) or [Create an account](/register) to join the conversation. Board Categories HikaShop Install & Update Product & Category Display Content Creation Sales and Orders Orders management Reports & Statistics Customers Checkout Payment Methods Shipping Methods Import & Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel & Slider Mass Actions Filters & Search Discount & Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.100 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)