..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
---------------
Jacob Skaria


"hoyos" wrote:

How do I number format this code to read ("###0")

.Range("J188") = .Range("J187").Value