Hi there, Am trying to solve a number formatting issue... I have a front end app that I need to be able to switch between
European Format - '#.##0' , ',' , '.' and
UK Format - '#,##0' , '.' , ','
However when I try to do this either using front end buttons with a variable I just can not get the formatting to work.... So what am I doing wrong. If I add the format in the format above with the '' it works fine. However the moment I use the '' in the variable it goes wrong....I have tried Chr(39) as well with &....! Any help gratefully appreciated.
