PDA

View Full Version : Eurpoean number format for prices

timiagama
10-Nov-2005, 07:20 AM
I need to have my prices formatted European style i.e. I want a comma where the dot normally is and vice versa.

So for the UK we would write 2,350.75
My client wants the price to read 2.350,75

Is there a setting somewhere that does this?
wjcampbe
10-Nov-2005, 08:28 AM
Changing the settings in Start | Control Panel | Regional settings would achieve this for current pages, but all the pages generated with this setting would pick up the changes - been trying to think if a way of telling the system each page is a different language.

Only way I can this is to include the correct Doctype declaration at the head of the HTML page - i.e. trying DE for German in place of the usual EN
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//DE" "http://www.w3.org/TR/REC-html40/loose.dtd">
see if that works.
cdicken
11-Nov-2005, 08:37 AM
If you are looking to change the number format for Euros in Actinic, then you will need Microsoft Access and need to open the ActinicCatalog.mdb database.

Then open the 'currencies' table, find the Euros row (third one down) and basically swap the values in the SMONDECIMALSEP and the SMONTHOUSANDSEP around.