Change decimal separator format in a wokbook

[poseido]

Hello!

I'd like one of my workbooks to have a different decimal separator than usual.
my system (spanis) uses "," as decimal separator, and "." as thousand separator.

I'd like one of my workbooks to use the oposite, (the usual english format, ".2 as decimal and "," as thousands; but only this workbook, I do nto want to change the systems default, or the Excel default.

is it possible trougt config or macros?

Many thanks in advance

 

[John Davis]

Hello!

I'd like one of my workbooks to have a different decimal separator than usual.
my system (spanis) uses "," as decimal separator, and "." as thousand separator.

I'd like one of my workbooks to use the oposite, (the usual english format, ".2 as decimal and "," as thousands; but only this workbook, I do nto want to change the systems default, or the Excel default.

is it possible trougt config or macros?

Many thanks in advance

Maybe something like these event codes:

In Thisworkbook Open module:

    With Application
         .UseSystemSeparators = False
         .DecimalSeparator = "."
        .ThousandsSeparator = ","      
    End With

WorkbookBeforeClose

    With Application
        .UseSystemSeparators = True        
    End With

 

[poseido]

Maybe something like these event codes:

In Thisworkbook Open module:

    With Application
         .UseSystemSeparators = False
         .DecimalSeparator = "."
        .ThousandsSeparator = ","      
    End With

WorkbookBeforeClose

    With Application
        .UseSystemSeparators = True        
    End With

Thanks!
It worked!

 

[John Davis]

Thanks!
It worked!

You're welcome. Glad it helped.