Seremela Posted December 31, 2012 Share Posted December 31, 2012 Hi, After using a module that changes the price on my products i have 4-6 numbers after the comma. This interferes with my payment module as they only accept 2 numbers after the comma and then i get an error code. Is there a way to remove every number after the comma in the database except for 2? Thanks in advance Link to comment Share on other sites More sharing options...
benjamin utterback Posted December 31, 2012 Share Posted December 31, 2012 Hello Seremela, which module did you use? Have you changed the settings of your currencies? in 1.5 it's under Localization>Currencies then you can edit the decimal formatting in each currency. Link to comment Share on other sites More sharing options...
Seremela Posted January 4, 2013 Author Share Posted January 4, 2013 Hi, thanks for the reply. I already got it solved by changing the type in phpmyadmin Was pretty simple to do. Link to comment Share on other sites More sharing options...
.png.022b5452a8f28f552bc9430097a16da2.png)
Recommended Posts