Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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) |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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) & "]" |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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" & "]" |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to add new currency Symbol in Format/Cell/Currency | Excel Discussion (Misc queries) | |||
Setting a minimum currency value | Excel Worksheet Functions | |||
Setting a string variable as the file name | Excel Discussion (Misc queries) | |||
Need help setting the worksheet header/Footer margins based on string height? | Excel Discussion (Misc queries) | |||
Setting character attributes in a text string | Excel Worksheet Functions |