Setting Thousands Separators for Numerics

[mveera]

Hi,

I would like to know how i can Change the Thousands Separator for Numerics in VBA. The application can be used in both Europe where it is "'" and other locations where it is ",". So i would like to make it standard across all locations.

Application.International(xlThousandsSeparator) is a readonly property.

Manually it can be done by changing the Regional Options in
Settings, Control Options. I would like to how i can do programmatically.

Thanks
Veera

 

[mveera]

Hi,

Is there any way of setting the Thousands Separator for a number.

Thanks
Veera

 

[bryanbayfield]

I think it would have to be done via the Windows API (Application Programming Interface) _I think_.

I'm pretty sure there's an API forum on here so you may be better off making this post on that forum.

Sorry not to be of further use.