See Err' Message in Excel VBE(VBA)
"Programmatic access to Visual Basic ProJect is not trusted"
|
|
Let's Find How Can Get More Easy Using MS Excel
[ Convert Number to DOLLAR (UDF NUM2DOLLAR97) ] Let's Look & Find ---> You Can Convert Number to DOLLAR Sample - 1 NUM2DOLLAR97 (Number) Default Money Display = Dollar(s) Sample - 2 NUM2DOLLAR97 (Number, "fran") | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
Used Formula ...(With Running MicrosoftExcel Ver 97) | ||||
No | Addr' | If use below Formula, You'll Get Result as Right | Result | Etc |
1 | B1 | =NUM2DOLLAR97(A1) | One Dollar. | |
2 | B1 His Formula Used This Cell -> B1:B33 | |||
3 | B34 | =NUM2DOLLAR97(A34,"franc") | One franc. | |
4 | B34 His Formula Used This Cell -> B34:B35 | |||
How about this suggest? |