Same column Percent and Currency

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello I have a column that contains numbers thatr represent both
percent and currency. Presently I formatted the column as number - general
Example 0.15 and 68 - 0.15 should read 15.00% and 68 should read
$68.00. Is there a formula so that I can format the number as percent or as
currency in the same column thanks
 
Assuming currency is greater or equal to 1 and percent is between .01 and
..99, sort your data by this column of numbers, so that all percent values are
grouped together and all currency values are grouped together and then apply
the correct formatting to each group.

Dave
 
Dave Brillant thanks

Dave F said:
Assuming currency is greater or equal to 1 and percent is between .01 and
.99, sort your data by this column of numbers, so that all percent values are
grouped together and all currency values are grouped together and then apply
the correct formatting to each group.

Dave
Click to expand...
 
You can use a custom format for the column, so that you *instantly* display
your desired format, where sorting is *unnecessary*.

[<1]0.00%;$#,##0.00

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

Dave Brillant thanks
 
RagDyeR
I tried the formula below and when I enter a percent value such as 12. I get
12.00% and that's fine, however when I enter a dollar value let's say 130.00
the answer is $1.30 what I'm I doing wrong thanks

RagDyeR said:
You can use a custom format for the column, so that you *instantly* display
your desired format, where sorting is *unnecessary*.

[<1]0.00%;$#,##0.00

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

Dave Brillant thanks
Click to expand...
 
You should *not* be entering 12. to display 12.00%
You should be using .12

SO ... That tells me that you have "Fixed Decimals" enabled.

Go to:
<Tools> <Options> <Edit> tab,
And *UNCHECK*
"Fixed Decimals"


--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================


RagDyeR
I tried the formula below and when I enter a percent value such as 12. I get
12.00% and that's fine, however when I enter a dollar value let's say 130.00
the answer is $1.30 what I'm I doing wrong thanks

RagDyeR said:
You can use a custom format for the column, so that you *instantly*
display
your desired format, where sorting is *unnecessary*.

[<1]0.00%;$#,##0.00

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

Dave Brillant thanks
Click to expand...
 
RagDyeR Thanks again I see my mistake I was entering currency numbers
with decimal. thanks for your help. this is brillant !

RagDyeR said:
You should *not* be entering 12. to display 12.00%
You should be using .12

SO ... That tells me that you have "Fixed Decimals" enabled.

Go to:
<Tools> <Options> <Edit> tab,
And *UNCHECK*
"Fixed Decimals"


--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================


RagDyeR
I tried the formula below and when I enter a percent value such as 12. I get
12.00% and that's fine, however when I enter a dollar value let's say 130.00
the answer is $1.30 what I'm I doing wrong thanks

RagDyeR said:
You can use a custom format for the column, so that you *instantly*
display
your desired format, where sorting is *unnecessary*.

[<1]0.00%;$#,##0.00

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

Dave Brillant thanks

Dave F said:
Assuming currency is greater or equal to 1 and percent is between .01
and
.99, sort your data by this column of numbers, so that all percent
values
are
grouped together and all currency values are grouped together and then
apply
the correct formatting to each group.

Dave
--
Brevity is the soul of wit.


:

Hello I have a column that contains numbers thatr represent both
percent and currency. Presently I formatted the column as number -
general
Example 0.15 and 68 - 0.15 should read 15.00% and 68 should
read
$68.00. Is there a formula so that I can format the number as percent
or
as
currency in the same column thanks
Click to expand...
Click to expand...
Click to expand...
 
You're welcome, and thanks for the feed-back.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
Wanna Learn said:
RagDyeR Thanks again I see my mistake I was entering currency numbers
with decimal. thanks for your help. this is brillant !

RagDyeR said:
You should *not* be entering 12. to display 12.00%
You should be using .12

SO ... That tells me that you have "Fixed Decimals" enabled.

Go to:
<Tools> <Options> <Edit> tab,
And *UNCHECK*
"Fixed Decimals"


--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================


RagDyeR
I tried the formula below and when I enter a percent value such as 12. I
get
12.00% and that's fine, however when I enter a dollar value let's say
130.00
the answer is $1.30 what I'm I doing wrong thanks

RagDyeR said:
You can use a custom format for the column, so that you *instantly*
display
your desired format, where sorting is *unnecessary*.

[<1]0.00%;$#,##0.00

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

Dave Brillant thanks

:

Assuming currency is greater or equal to 1 and percent is between .01
and
.99, sort your data by this column of numbers, so that all percent
values
are
grouped together and all currency values are grouped together and
then
apply
the correct formatting to each group.

Dave
--
Brevity is the soul of wit.


:

Hello I have a column that contains numbers thatr represent
both
percent and currency. Presently I formatted the column as
number -
general
Example 0.15 and 68 - 0.15 should read 15.00% and 68 should
read
$68.00. Is there a formula so that I can format the number as
percent
or
as
currency in the same column thanks
Click to expand...
Click to expand...
Click to expand...
 
Back
Top