Hi,
Iäm running excel on Windows set to English (Great Britain) region settings.
Standard thousand separator is ","
I'm creating a financial document presenting an income statement with english and swedish formatting side by side.
Since English is my setting, iäm trying to use custom formatting to generate the swqeidh number format.
Thousand separator skuld be " "; space
There should be no decimals.
Zero should be just "-"
I'm currently using the following custom formatting:
# ##0;-# ##0;"-"
Works just fine, besides negative amounts less than a thousand.
-2000 => "-2 000"
-200 => "- 200"
There's a space between "-" and the amount when the amount is beneeth a thousand.
Why!?
Bookmarks