Thank you Jacob that will do nicely!!

"Jacob Skaria" wrote:

.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