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)