Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
#2
![]() |
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Insert more than 1 Row Syntax | Excel Worksheet Functions | |||
Rate syntax | Excel Discussion (Misc queries) | |||
WHAT SYNTAX IS USED TO ROUND A 4-DIGIT NUMBER TO THE NEAREST THOUS | Excel Discussion (Misc queries) | |||
Vlookup Syntax Error | New Users to Excel | |||
Previous Post - Correct Syntax Query | Excel Worksheet Functions |