VBA syntax

S

Sunantoro

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
 
R

Rowan

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

Hope this helps
Rowan
 
Top