Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code format question
Hi Group,
Just for the life of me can not remember the code which I used in the past to format combined variables. First Variable should be (Fixed,Comma,2) and the second should be as a %. It is the Fixed, Comma, 2 I am having trouble with. Done it before, just can't remember. Thanks, David |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code format question
Hi Again,
I found the example where I hd used it before, but it was used in a formula. Not a help. "David" wrote: Hi Group, Just for the life of me can not remember the code which I used in the past to format combined variables. First Variable should be (Fixed,Comma,2) and the second should be as a %. It is the Fixed, Comma, 2 I am having trouble with. Done it before, just can't remember. Thanks, David |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code format question
Stuck.
This what what I currently have: ActiveCell.Offset(0, 2).Value = Wk4Avg & "/" & (Wk4AvgPer * 100) & "%" and it puts this in the cell: 53.255/-2.27104339813363% What I would like as the ending value is: 53.26/-2.27% Any help would be appreciated. Thanks, David "David" wrote: Hi Group, Just for the life of me can not remember the code which I used in the past to format combined variables. First Variable should be (Fixed,Comma,2) and the second should be as a %. It is the Fixed, Comma, 2 I am having trouble with. Done it before, just can't remember. Thanks, David |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code format question
Got it. Now it seems so simple. Must be getting old, memory the first thing
to go? "David" wrote: Hi Group, Just for the life of me can not remember the code which I used in the past to format combined variables. First Variable should be (Fixed,Comma,2) and the second should be as a %. It is the Fixed, Comma, 2 I am having trouble with. Done it before, just can't remember. Thanks, David |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Question on this conversion code switching between r1c1 to A1 format tia sal2 | Excel Worksheet Functions | |||
Question on this conversion code switching between r1c1 to A1 format tia sal2 | Excel Discussion (Misc queries) | |||
Question on this conversion code switching between r1c1 to A1 format tia sal2 | Excel Worksheet Functions | |||
Question on this conversion code switching between r1c1 to A1 format tia sal2 | Excel Programming | |||
Leo Heuser format cleanup code, and a question | Excel Programming |