Dr or Cr Custom Number Format - Explanation Needed

[Alienontherun]

Hi

I saw a custom number format that displays Dr after the number (if the number is positive), or Cr (if the number is negative) as in the screenshot below.

Can someone explain how exactly this custom format works, please.

https://s25.postimg.org/iudfv2egv/De...tom_Format.jpg

Thank you.

[cytop]

See the first result for a detailed explanation of number formats.

[Norie]

The number format string is split into 4 parts separated by semi-colons.

The first part is the format to use for positive numbers.

The second part the format for negative numbers.

The third part the format for 0.

The fourth part for text values.

Anything in quotes in the formats, eg Dr or Cr, will appear as is.

So what you are seeing is using the format 0 "Dr" for positive numbers, 0 "Cr" for negative numbers and 0 for, well, 0.

Hope that explains a bit how the format you are seeing works.

[Alienontherun]

The number format string is split into 4 parts separated by semi-colons.

The first part is the format to use for positive numbers.

The second part the format for negative numbers.

The third part the format for 0.

The fourth part for text values.

Anything in quotes will in the formats, eg Dr or Cr, will appear as is.

So what you are seeing is using the format 0 "Dr" for positive numbers, 0 "Cr" for negative numbers and 0 for, well, 0.

Hope that explains a bit how the format you are seeing works.

Thank you for your explanation and kindness.