Is there a print using function or some way to limit the number of decimal places that the text function shows? I realize I can convert to a string and truncate but I'm hoping there's a more direct way.
Thanks,
Barry
Thanks,
Barry
Global blank$ = " " ;or blank$ = "" or whatever you choose Function Digit$(intdigits, decdigits, number#, zeros=False, leadingzeros=True) If Sgn(number#) >= 0 intnum = Floor(number#) Else intnum = Ceil(number#) sign = True EndIf integer$ = intnum If integer$ = "0" integer$ = "" Else sign = False EndIf decnum# = number# * 10000 dec$ = decnum# dot = Instr(dec$, ".", 1) dec$ = Left$(dec$, dot - 1) dec$ = Right$(dec$, 4) While Len(dec$) < 4 dec$ = "0" + dec$ Wend For iter = intdigits To 1 Step -1 If integer$ <> "" newstr$ = Right$(integer$, 1) + newstr$ Else If sign = True newstr$ = "-" + newstr$ sign = False iter = iter - 1 EndIf If (zeros = False Or leadingzeros = False) And iter > 0 newstr$ = blank$ + newstr$ Else newstr$ = "0" + newstr$ EndIf EndIf integer$ = Left$(integer$, Len(integer$) -1) Next If decdigits > 0 newstr$ = newstr$ + "." For iter = 1 To decdigits If dec$ <> "" newstr$ = newstr$ + Left$(dec$, 1) Else If zeros = False newstr$ = newstr$ + blank$ Else newstr$ = newstr$ + "0" EndIf EndIf dec$ = Right$(dec$, Len(dec$) - 1) Next EndIf Return newstr$ End Function