Custom Cell Format Dr or Cr

Custom Cell Format Dr or Cr - Positive amount suffixed with ‘Dr’ and negative amount suffixed with “Cr

Custom Number Format is divided into 4 parts:

#,## \D\r;#,## \C\r;-;"Enter Number only"

1. Positive value
2. Negative value
3. Zero
4. The alert message, if alphabets are entered instead of numbers

S.No	Symbol	Meaning
1.	#	It ignores the insignificant zeros
2.	,	It helps to separate thousands.
3.	\	Helps to display the next character (i.e. to print D, we need to put the symbol in front of D)
4.	;	Helps to separate 4 format types (i.e. positive number, negative number, zero, alert text.
5.	-	Just used to represent the ‘Zero’ (we can also enter ‘0’ or text ‘Zero’ to represent the value zero)
6.	""	All the text should be given in the inverted commas.