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.
Thanks