with cells(5,2)
.value = 2000
.numberformat = "$#,##0"
end with

Hope this helps
Rowan


Sunantoro wrote:
If I define Cell B5's Value to be $2000
what is the VB syntax that Cell B5 will now shows "$2000"?
Sorry, this is very basic
Thanks,
SUNAN