number of case conversion excel

Users questions: I had already been answered, but the reality is somewhat different answers. I hope that the lower case is text form, 11235, no punctuation, and a box blank between each number. Hope to get everyone's help. Pulsatilla, Hello! You give me the answer, the amount of monetary forms 13,111 .12 In this form, I hope this form of 1,311,112 no punctuation, but the middle should have a space, the only way to meet the collection credentials print format. 1,311,112 are written above each number 10000, 1000, 100, pick up and cents, and no punctuation was. Had in the bank shall It, turn it off. Always fill out their lowercase. Is the kind of format.
Experts answer:excel case conversion figures I have given you the answer, the answer and the actual are not the same. Can describe in detail. I understand your question to add meaning, is not the use of blank bank notes collection , In the above directly to print. Please reply and be OK. Hello sister school to cherish: Your question can not be solved in 2003 inside. According to your requirements, lower case of each number will need to occupy a cell, if needed to reach 7 million cells, the RMB capital is based within a cell Figures, with the IF function to judge, and now can only nest 7 2003IF function layer, if you want to combine multiple cells into one by judging the number of cells within the capital, for the time being can not be achieved. Recommendation: In the print set up outside the auxiliary cell, lower case number in this re-entry, capital Amount between the auxiliary cell formula on OK. Inadequacy is a lower-case figures to re-entry.
  • This information provided by the users.Thanks!