" When converting numbers to uppercase, the format function dbnum2 sometimes fails, and the output is the same as the input. What could be the reason for the failure of dbnum2? "
Numbers are not converted to uppercase
01
—
How to use the function dbnum2
This formula can be applied to capitalize the amount: ="Euro"&IF(ABS(Cell)<0.005,"",IF(Cell<0,"negative",)&IF(INT(ABS(Cell)),TEXT(INT(ABS( Cell)),"[dbnum2]")&"Element",)&IF(INT(ABS(Cell)*10)-INT(ABS(Cell))*10,TEXT(INT(ABS(Cell)*10)- INT(ABS(Cell))*10,"[dbnum2]")&"corner",IF(INT(ABS(Cell))=ABS(Cell),,IF(ABS(Cell)<0.1,,"zero" )))&IF(ROUND(ABS(Cell)*100-INT(ABS(Cell)*10)*10,),TEXT(ROUND(ABS(Cell)*100-INT(ABS(Cell)*10)*10 ,),"[dbnum2]")&"Min","Whole"))
where cell is the cell where the final result is to be displayed.
02
—
Possible reasons for the failure of dbnum2
We know that excel has two languages, one is the display language, which is the language in which buttons, menus and other controls are displayed, and the other is the authoring language and proofing, which manages the language used to create and edit documents, such as:
Then one of the possible reasons for the failure of dbnum2 is the wrong settings of the office authoring language and proofreading; in this item, when Chinese (China) is set as the preferred language, dbnum2 can work normally.
In the operating system using the English version, this error is most likely to be caused. We only need to change the corresponding office creation language and school team to Chinese (China).