Danish or German Number Format

  • Thread starter Thread starter Bill
  • Start date Start date
B

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
 
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
 
Harald

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

Harald Staff said:
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 said:
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
Click to expand...
Click to expand...
 
Back
Top