This problem only appear on a computer, a certain number of columns, the data window format set the display format is amount $#, # # 0.00, when numerical more than all, show only the thousand, 95000, for example, show that RMB 9500.00; 950000, also shows that RMB 9500.00, if the format does not use RMB symbol, is normal, good strange,

CodePudding user response:

#, # # 0.00 you that adding a little more like $#, # # #, # # #, # # 0.00

CodePudding user response:

\ $#, # # 0.00

Take a look at

CodePudding user response:

Tested were not ok, show is not the correct format,

CodePudding user response:

refer to the original poster gzlonten response:

this problem only appear on a computer, a certain number of columns, the data window format set the display format is amount RMB #, # # 0.00, when numerical more than all, show only the thousand, 95000, for example, show that RMB 9500.00; 950000, also shows that RMB 9500.00, if the format does not use RMB symbol, is normal, good strange,

After pb8 didn't find the original poster said, use $#, # # 0.00, 95000 can display properly for RMB 95000.00, not the original poster said problems

After pb10 pb12 test, there will be a the original poster said, is set to $#, # # 0.00, 95000 shows at RMB 9500.00, but changed the mask to RMB # # # # 0.00, can be shown as RMB 95000.00, after test, found that using the $#, # # 0.00 does not have this problem, the analysis is due to Chinese characters

The landlord don't tangle, instead RMB # # #, # # 0.00 can display

CodePudding user response:

reference gzlonten reply: 3/f

tested, all can't, show is not the right format,

Alas, why I try no problem?

CodePudding user response:

The building Lord you go here look at the control panel - regional and language - format - other Settings - currency