Point and comma problem

[Gert-Jan]

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

 

[Guest]

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 Tools>Options>International.

If it's the latter, can you give an example of the problems it's causing?

Marion

 

[Gert-Jan]

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

 

[Gert-Jan]

It is a problem with my keyboard, I see now. Very strange: only in Excel.