Danish or German Number Format

[Bill]

Dear All

To format a 1000 number such as 12,897.45 to show 12,9 we use the following
custom format cell.

#,##0.0,"K"_);[Red](#,##0.0,"K)";0"K"_);@

Does anyone know the equivalent Danish or German format, i.e. when regional
settings are set to Danish(Denmark).

Thanks in advance.
Alan

 

[Harald Staff]

Hi Alan

I believe those formats will adjust themselves to te regional settins in
question. You can change country/regional settings in the control panel
yourself and check it out.

HTH. Best wishes Harald

 

[Bill]

Harald

Thank you so much for your assistance. It was most useful in resolving my
issue.

Hi Alan

I believe those formats will adjust themselves to te regional settins in
question. You can change country/regional settings in the control panel
yourself and check it out.

HTH. Best wishes Harald

Dear All

To format a 1000 number such as 12,897.45 to show 12,9 we use the
following custom format cell.

#,##0.0,"K"_);[Red](#,##0.0,"K)";0"K"_);@

Does anyone know the equivalent Danish or German format, i.e. when
regional settings are set to Danish(Denmark).

Thanks in advance.
Alan

 

[Harald Staff]

Good. Thank you for the feedback.

Best wishes Harald