Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Point and comma problem
Hi,
In my Excel-worksheets the standard comma in a number (1,25) is unexpectedly changed in a point (1.25). Although VBA places a comma ( for example when I move some values from a form to excel) this leads to errors. Can anyone tell me how to change it? Regards, Gert-Jan |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Point and comma problem
Hello Gert-Jan,
I'm not sure if you want to change the way Excel displays the decimal separator in a number, or if you just want to get around the problems that you're having. If it's the former, you can change the way Excel shows the decimal separator by going to ToolsOptionsInternational. If it's the latter, can you give an example of the problems it's causing? Marion "Gert-Jan" wrote: Hi, In my Excel-worksheets the standard comma in a number (1,25) is unexpectedly changed in a point (1.25). Although VBA places a comma ( for example when I move some values from a form to excel) this leads to errors. Can anyone tell me how to change it? Regards, Gert-Jan |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Point and comma problem
Hi Marion,
Thanks for responding. I found your solution already. If I uncheck the International Option, my worksheets works fine again. But, normally it is checked.... There is a strange thing: every number from my VBA form with a comma in it, cannot be displayed in ?, or some other changing of the format...(placing more decimals). Very, very strange.... But, calculating is possible. Regards, Gert-Jan "Marion" schreef in bericht ... Hello Gert-Jan, I'm not sure if you want to change the way Excel displays the decimal separator in a number, or if you just want to get around the problems that you're having. If it's the former, you can change the way Excel shows the decimal separator by going to ToolsOptionsInternational. If it's the latter, can you give an example of the problems it's causing? Marion "Gert-Jan" wrote: Hi, In my Excel-worksheets the standard comma in a number (1,25) is unexpectedly changed in a point (1.25). Although VBA places a comma ( for example when I move some values from a form to excel) this leads to errors. Can anyone tell me how to change it? Regards, Gert-Jan |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Point and comma problem
It is a problem with my keyboard, I see now. Very strange: only in Excel.
"Gert-Jan" schreef in bericht ... Hi Marion, Thanks for responding. I found your solution already. If I uncheck the International Option, my worksheets works fine again. But, normally it is checked.... There is a strange thing: every number from my VBA form with a comma in it, cannot be displayed in ?, or some other changing of the format...(placing more decimals). Very, very strange.... But, calculating is possible. Regards, Gert-Jan "Marion" schreef in bericht ... Hello Gert-Jan, I'm not sure if you want to change the way Excel displays the decimal separator in a number, or if you just want to get around the problems that you're having. If it's the former, you can change the way Excel shows the decimal separator by going to ToolsOptionsInternational. If it's the latter, can you give an example of the problems it's causing? Marion "Gert-Jan" wrote: Hi, In my Excel-worksheets the standard comma in a number (1,25) is unexpectedly changed in a point (1.25). Although VBA places a comma ( for example when I move some values from a form to excel) this leads to errors. Can anyone tell me how to change it? Regards, Gert-Jan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how replace comma with point in import data | Excel Worksheet Functions | |||
Suddently when we type in . (dot or point) become comma in excel | Excel Discussion (Misc queries) | |||
export to csv file (comma problem) | Excel Programming | |||
Decimal point/comma issue | Excel Discussion (Misc queries) | |||
Problem with comma seperated list | Excel Programming |