在excel中如何讲阿拉伯数字格式转化为大写货币格式,例如表格中为2.3元...答:打开VB编辑器,新建一模块,输入以下代码:Public Function RMBDX(M)RMBDX = Replace(Application.Text(Round(M + 0.00000001, 2), "[DBnum2]"), ".", "元")RMBDX = IIf(Left(Right(RMBDX, 3), 1) = "元", Left(RMBDX, Len(RMBDX) - 1) & "角" & Right(RMBDX, 1) & "...