Mfcttrf

I'm trying to align some money in a table using the S column type of the siunitx package, but the € symbol keeps running wild (inconsistent alignment).

Using the eurosym package helps with the alignment but puts the currency symbol up front and I would like to have it behind the number. Any suggestions?

documentclassarticle 
usepackage[ngerman]babel
usepackage[locale = DE]siunitx
usepackage[gen]eurosym

begindocument 

begintable[h]
 centering
 begintabular 

 hline
 A & B & C & D \ 
 hline
 -199,37 € & 0,00 € & 33,27 € & 166,10 € \
 252,56 € & 0,00 € & -409,58 € & 157,02 € \
 104,67 € & 0,00 € & -40,18 € & -64,48 € \
 0,17 € & 0,00 € & -2,52 € & 2,35 € \
 0,00 € & 0,00 € & 0,00 € & 0,00 € \
 hline

 endtabular
endtable

begintable[h]
 centering
 begintabular 

 hline
 A & B & C & D \ 
 hline
 euro-199,37 & euro0,00 & euro33,27 & euro166,10 \
 euro252,56 & euro0,00 & euro-409,58 & euro157,02 \
 euro104,67 & euro0,00 & euro-40,18 & euro-64,48 \
 euro0,17 & euro0,00 & euro-2,52 & euro2,35 \
 euro0,00 & euro0,00 & euro0,00 & euro0,00 \
 hline

 endtabular
endtable

enddocument

With the appropriate table-format option for the individual cells as well as with table-space-text-post=€ and table-align-text-post=true you can get the following output:

documentclassarticle 
usepackage[ngerman]babel
usepackage[locale = DE]siunitx
usepackage[gen]eurosym

begindocument 

begintable[h]
sisetuptable-space-text-post=€, table-align-text-post=true
 centering
 begintabularS[table-format=-3.2] 

 hline
 A & B & C & D \ 
 hline
 -199,37 € & 0,00 € & 33,27 € & 166,10 € \
 252,56 € & 0,00 € & -409,58 € & 157,02 € \
 104,67 € & 0,00 € & -40,18 € & -64,48 € \
 0,17 € & 0,00 € & -2,52 € & 2,35 € \
 0,00 € & 0,00 € & 0,00 € & 0,00 € \
 hline

 endtabular
endtable
enddocument

To avoid repeating the € symbol over and over again, I'd either put it into the column header of the corresponding columns or even into the caption of the table.

What about this?

documentclassarticle
usepackage[ngerman]babel
usepackage[T1]fontenc
usepackage[locale = DE]siunitx
usepackagetextcomp
usepackagebooktabs, makecell
newcommandmc[1]multicolumn1c#1

begindocument

begintable[h]
 centering
setcellgapes3pt
makegapedcells
sisetuptable-space-text-post=,€, 
 table-align-text-post=false
 begintabularS[table-format=-3.2]<,€
 S[table-format= 1.2]<,€ 
 *2S[table-format=-3.2]<,€
 
 toprule
mcA & mcB & mcC & mcD cr
 midrule
-199,37 & 0,00 & 33,27 & 166,10 cr
 252,56 & 0,00 & -409,58 & 157,02 cr
 104,67 & 0,00 & -40,18 & -64,48 cr
 0,17 & 0,00 & -2,52 & 2,35 cr
 0,00 & 0,00 & 0,00 & 0,00 cr
 bottomrule
 endtabular
endtable

enddocument 

I would like to suggest an alternative solution: put the euro sign in the column headers.

And egreg suggests to use eurosym without the gen option, this way the euro symbol is more beautiful.

documentclassarticle 
usepackage[ngerman]babel
usepackage[locale = DE]siunitx
usepackageeurosym
usepackagebooktabs
begindocument 
begintable[h]
 centering
 begintabularSSSS 
 toprule 
 A (euro) & B (euro) & C (euro) & D (euro) \ 
 midrule
 -199,37 & 0,00 & 33,27 & 166,10 \
 252,56 & 0,00 & -409,58 & 157,02 \
 104,67 & 0,00 & -40,18 & -64,48 \
 0,17 & 0,00 & -2,52 & 2,35 \
 0,00 & 0,00 & 0,00 & 0,00 \
 bottomrule 
 endtabular
endtable
Or:
begintable[h]
 centering
 begintabularSSSS 
 toprule 
 A & B & C & D \ 
 (euro) & (euro) & (euro) & (euro) \ 
 midrule
 -199,37 & 0,00 & 33,27 & 166,10 \
 252,56 & 0,00 & -409,58 & 157,02 \
 104,67 & 0,00 & -40,18 & -64,48 \
 0,17 & 0,00 & -2,52 & 2,35 \
 0,00 & 0,00 & 0,00 & 0,00 \
 bottomrule 
 endtabular
endtable
enddocument

Fundamentally same solution, but slightly improved with a thin unbreakble space between number and euro, and some padding at toˆof rows with extrarowheight:

documentclassarticle
usepackage[ngerman]babel
usepackage[utf8]inputenc
usepackage[T1]fontenc
usepackagelmodern
usepackage[locale = DE]siunitx
usepackagetextcomp
setlengthextrarowheight2pt

begindocument

begintable[h]
 centering
sisetuptable-format =-3.2, table-number-alignment=center, table-space-text-post=€, table-align-text-post=false
 begintabular
 hline
 A & B & C & D \
 hline
 -199,37,€ & 0,00 ,€ & 33,27 ,€ & 166,10 \
 252,56 ,€ & 0,00 ,€ & -409,58 ,€ & 157,02 ,€ \
 104,67 ,€ & 0,00 ,€ & -40,18 ,€ & -64,48 ,€ \
 0,17 ,€ & 0,00 ,€ & -2,52 ,€ & 2,35 ,€ \
 0,00 ,€ & 0,00 ,€ & 0,00 ,€ & 0,00 ,€ \
 hline
 endtabular
endtable

enddocument 

Since so many have provided solution, I provide one using threeparttable to set a note in the caption regarding euro, and with columns of equal width (using array's w-column).

documentclassarticle 
usepackage[ngerman]babel
usepackagebooktabs, caption,array
usepackage[flushleft, online]threeparttable
begindocument 

begintable
centering
beginthreeparttable
captionCaption for table~reftab:a, which has both a tablenotetnotea and a label labeltab:a
begintabular@*4wr1.3cm@ 
toprule 
multicolumn1wc1cmsmall A & multicolumn1wc1cmkern1.2emsmall B &
multicolumn1wc1cmkern1emsmall C & multicolumn1wc1cm@kern1emsmall D \ 
midrule
$-$199,37 & 0,00 & 33,27 & 166,10 \
 252,56 & 0,00 & $-$409,58 & 157,02 \
 104,67 & 0,00 & $-$40,18 & $-$64,48 \
 0,17 & 0,00 & $-$2,52 & 2,35 \
 0,00 & 0,00 & 0,00 & 0,00 \
bottomrule
endtabular
begintablenotes
item [a] All numbers are in Euro
endtablenotes
endthreeparttable
endtable
enddocument