Vba excel convert cell to Hebrew currency (ILS) -
i trying convert cells numbers hebrew currency format, instead of getting sign of currency question mark sign in example attached. i've rerecorded macro doesn't seem work
range("i4", "i" & lastrow).numberformat = _ "_ [$?-40d] * #,##0.00_ ;_ [$?-40d] * -#,##0.00_ ;_ [$?-40d] * ""-""??_ ;_ @_ "
thank in advance, appreciate lot if answer question
the vba editor doesn't recognize hebrew currency symbol can use ascii character instead. 1 looking chrw(8362). found correct character code this website.
example:
activecell.numberformat = _ "_ [$" & chrw(8362) & "-10d] * #,##0.00_ ;_ [$" & chrw(8362) & "-10d] * -#,##0.00_ ;_ [$" & chrw(8362) & "-10d] * ""-""tt_ ;_ @_ "
result:
Comments
Post a Comment