Setting currency as string
 

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

Setting currency as string
 

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)

Setting currency as string
 

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) &
"]"

Setting currency as string
 

On Tue, 25 Oct 2011 01:44:00 -0700 (PDT), Sonnich Jensen wrote:

Or

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

I cannot comment since I have no idea what is contained in sh1.Cells(i,iValuuta). I'll guess it contains "ABC" without the quotes.

I suspect, though, that the "\" is unneccessary. At least it would be unneccessary in the US version of Excel, but it doesn't hurt to have it there.

Setting currency as string
 

On Oct 25, 12:54*pm, Ron Rosenfeld wrote:
On Tue, 25 Oct 2011 01:44:00 -0700 (PDT), Sonnich Jensen wrote:
Or

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

I cannot comment since I have no idea what is contained in sh1.Cells(i,iValuuta). *I'll guess it contains *"ABC" without the quotes.

I suspect, though, that the "\" is unneccessary. *At least it would be unneccessary in the US version of Excel, but it doesn't hurt to have it there.

SomeSheet.Cells(j, 2).NumberFormat = "0.00\ [$" & "ABC" & "]"

Setting currency as string
 

On Fri, 4 Nov 2011 08:54:12 -0700 (PDT), Sonnich Jensen wrote:

On Oct 25, 12:54*pm, Ron Rosenfeld wrote:
On Tue, 25 Oct 2011 01:44:00 -0700 (PDT), Sonnich Jensen wrote:
Or

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

I cannot comment since I have no idea what is contained in sh1.Cells(i,iValuuta). *I'll guess it contains *"ABC" without the quotes.

I suspect, though, that the "\" is unneccessary. *At least it would be unneccessary in the US version of Excel, but it doesn't hurt to have it there.

SomeSheet.Cells(j, 2).NumberFormat = "0.00\ [$" & "ABC" & "]"


Do you have a question? If so, please be explicit.