Hallo allerseits,
Rainers Formel hat mich zu folgendem inspiriert:
für 1 <= S17 <= 999,999,999,999.99:
=WECHSELN(WECHSELN(WECHSELN(WECHSELN(WECHSELN(TEXT(A1;"#.###.###.###,00"); ","; "§"; 1); "."; ","; 1);"."; ","; 2);"."; ","; 3); "§"; "."; 1)
für 0.01 <= S17 <= 999,999,999,999.99 (d. h. Zahlen < 1 mit führender Null):
=WECHSELN(WECHSELN(WECHSELN(WECHSELN(WECHSELN(TEXT(A1;"#.###.###.##0,00"); ","; "§"; 1); "."; ","; 1);"."; ","; 2);"."; ","; 3); "§"; "."; 1)
Allen einen schönen 3.Adventabend!
Charlotte