Decimal seperators?

[therock003]

What's better to set the decimal seperatos inside excel for decimals to be point and thousands to be commas,or to set them directly as system parameters from inside regional settings?

I know how to do both methods but i'm asking for your experience as to if there's a reason to just tamper the seperators from inside excel locally and not do it globally.

One other small thing.I ntoce manu guys here when providing equations they use comma as an argument instead of a semicolon which i seem to be using.

 

[Cbrine]

Not sure about the semicolon vs the colon bit, maybe a different language version of Excel? That's the only thing I can think of.

As far as the settings for displaying numbers, I would recommend that you stay away from the regional settings, and leave them as defaults. The reason is that some customized software may not look at how you have them set, and you could end up with months and days reversed in some cases. One of our programmers had messed with his regional settings, and one of the pieces of software he designed would only work correctly when the regional settings for short date we set to the same as his. Took a while to figure out why the problem was occurring.

HTH
Cal

 

[therock003]

I see thank you.So for the thousands what is the usual setting?Cause it would be strange to set commas as thousand seperators,but using points as decimals is a no brainer.

As for the semicolons,honestly that's the way my arguments are taken into account rather than using commas which for me it doesn work.It jus seems strange that everybody here pastes forumlas with commas as the argument of expression.

 

[Fazza]

Honestly something I have never dealt with. Maybe these are relevant, I don't know. VBA help refers, .FormulaLocal & .FormulaR1C1Local.

Other 'local' properties - AddressLocal, CategoryLocal & NameLocal.

Souns like you know about application.international(... property. VBA help refers.

Regards, Fazza