S
StumpedAgain
I'm trying to make some cell values integers. The database saves the
fractions as a string and I can't seem to get them to convert to integers so
that I can round them.
What I'd like:
0.135450617647059 (string)
to
0.135 (integer or string... guess I don't really care)
What I've tried:
x = Round(Val(ActiveSheet.Cells(brow, "K")), 3)
y = Round(ActiveSheet.Cells(crow, "J"), 3)
I've tried using Val and CInt and they didn't work for me. Any suggestions?
Thanks!
fractions as a string and I can't seem to get them to convert to integers so
that I can round them.
What I'd like:
0.135450617647059 (string)
to
0.135 (integer or string... guess I don't really care)
What I've tried:
x = Round(Val(ActiveSheet.Cells(brow, "K")), 3)
y = Round(ActiveSheet.Cells(crow, "J"), 3)
I've tried using Val and CInt and they didn't work for me. Any suggestions?
Thanks!