论文部分内容阅读
2000年第一期《中国会计电算化》杂志上介绍了三种实现人民币大写的方法,前两种方法是用“内置函数法”,但实现的人民币大写“元”、“角”、“分”要分别占用一整列的单元格,这在编制只有合计需要转换人民币大写的表格时,使用很不方便。后一种方法是用“VBA编程法”,虽然解决了“元、角、分”分别占用整列的单元格的问题,但由于编程工作量大易错,且每次打开该工作表时都要提问“是否打开宏文件”等问题。多有一些不便,有没有
In the first issue of “Accounting Computerization in China” in 2000, there are introduced three ways to realize the capitalization of RMB. The first two methods use the “built-in function method”, but the RMB capitalization “yuan”, “angle” and “ Points ”to occupy an entire column of cells, which in the preparation of only the total need to convert RMB capital form, very inconvenient to use. The latter method is to use the “VBA programming method”, although the solution to the “yuan, angle, points” occupied by the entire column of the cell, but due to a large amount of programming error-prone, and each time you open the worksheet Question “whether to open the macro file” and other issues. More inconvenience, no