Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
String to Rounded Integer
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
convert string to integer | Excel Programming | |||
Varaibles as both integer and String | Excel Programming | |||
String or integer? | Excel Programming | |||
Compare string with integer | Excel Programming | |||
Concatenating a string and an integer | Excel Programming |