H hoyos Nov 8, 2009 #1 How do I number format this code to read ("###0") ..Range("J188") = .Range("J187").Value
J Jacob Skaria Nov 8, 2009 #2 ..Range("J188") = .Range("J187").Value ..RANGE("J188").NumberFormat = "###0" 'if you want to change the value then ..Range("J188") = Round(.Range("J187").Value) If this post helps click Yes
..Range("J188") = .Range("J187").Value ..RANGE("J188").NumberFormat = "###0" 'if you want to change the value then ..Range("J188") = Round(.Range("J187").Value) If this post helps click Yes
H hoyos Nov 8, 2009 #3 Thank you Jacob that will do nicely!! Jacob Skaria said: .Range("J188") = .Range("J187").Value .RANGE("J188").NumberFormat = "###0" 'if you want to change the value then .Range("J188") = Round(.Range("J187").Value) If this post helps click Yes Click to expand...
Thank you Jacob that will do nicely!! Jacob Skaria said: .Range("J188") = .Range("J187").Value .RANGE("J188").NumberFormat = "###0" 'if you want to change the value then .Range("J188") = Round(.Range("J187").Value) If this post helps click Yes Click to expand...
