G
Guest
VBA in Polish Excel 2003 has a serious problem with separator !!!
In polnad we use "," insead "." as and we use "." insead "," as thousand
separator
for exampel number: 1/4 as 0,25 in USA standard its 0.25 as I use commend
for example find and change "." for empty its change "." and ",".
Second more seriuos problem its formnts like comobox; texbox.
if I creat userform with texbox and I set controlsource for example a1
if I enter textbox and write 20,3 then in cell A1 will appear 20,3 but as
for excell its not value and often it shoutdown and tell me that apear a
serious problem with excell.
If a change system separators for USA stnadards its does not work either.
Problem with separators in VBA for Excel its serious limit my ablility to do
in fast way financial symulations and
analysis. I called to Polish center one year ago but for them that probelm
doesn't exist because they don't have it in their base of knowladge.!!!????!!!
I hope You will be able to help me and thousands of Excel users in Polnad
and my be in other countries where is either standard of separators like in
Poland. I look forward for office updates.
Å.S.
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/com...c2c7eed&dg=microsoft.public.excel.crashesgpfs
In polnad we use "," insead "." as and we use "." insead "," as thousand
separator
for exampel number: 1/4 as 0,25 in USA standard its 0.25 as I use commend
for example find and change "." for empty its change "." and ",".
Second more seriuos problem its formnts like comobox; texbox.
if I creat userform with texbox and I set controlsource for example a1
if I enter textbox and write 20,3 then in cell A1 will appear 20,3 but as
for excell its not value and often it shoutdown and tell me that apear a
serious problem with excell.
If a change system separators for USA stnadards its does not work either.
Problem with separators in VBA for Excel its serious limit my ablility to do
in fast way financial symulations and
analysis. I called to Polish center one year ago but for them that probelm
doesn't exist because they don't have it in their base of knowladge.!!!????!!!
I hope You will be able to help me and thousands of Excel users in Polnad
and my be in other countries where is either standard of separators like in
Poland. I look forward for office updates.
Å.S.
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/com...c2c7eed&dg=microsoft.public.excel.crashesgpfs