On Oct 24, 9:17*pm, Ron Rosenfeld wrote:
On Mon, 24 Oct 2011 10:32:29 -0700 (PDT), Sonnich Jensen wrote:
Hi all

Is it possible to set a currency from a string?
Say I have "ABC" and want to use that as a currency?

I want to set it from VBA code

WBR
Sonnich

Just use the same format you would use on the worksheet when setting the NumberFormat property. *Depending on whether you want the currency at the start or end of the numbers, maybe something like: * *[$ABC] #,##0_);[Red][$ABC] (#,##0)

Or

sh2.Cells(j, 2).NumberFormat = "0.00\ [$" & sh1.Cells(i, iValuuta) &
"]"