Decimal formatting

[michiel mobach]

Hello,

does anybody know if there is some way of making a format of numbers
(decimals) the dutch way. I'm using excel for my invoices but it formats the
american way so now if have to retype the caclulations. Maybe it is a
version problem i don't know.....I tried using cusom formatting of numbers
but my excal won't do calculations any more.

Dutch formatting decimals #.###,00
American formatting decimals #,###.00

So where i need a 'period' i get a 'comma' and vise versa

Thanks in advance

Michiel Mobach.

 

[JE McGimpsey]

does anybody know if there is some way of making a format of numbers
(decimals) the dutch way. I'm using excel for my invoices but it formats the
american way so now if have to retype the caclulations. Maybe it is a
version problem i don't know.....I tried using cusom formatting of numbers
but my excal won't do calculations any more.

Dutch formatting decimals #.###,00
American formatting decimals #,###.00

So where i need a 'period' i get a 'comma' and vise versa

What version of XL are you using?

XL takes decimal and thousands separators from your system preferences,
so if your system preferences are set for US format, that's what XL will
use.

That said, if you're using an early version of XLv.X, there were
problems picking up the localization. Try updating to at least version
10.1.4 (but I'd recommend 10.1.6).