Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Same column Percent and Currency
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Same column Percent and Currency
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. "Wanna Learn" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Same column Percent and Currency
Dave Brillant thanks
"Dave F" wrote: 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. "Wanna Learn" wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Same column Percent and Currency
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! ================================================== === "Wanna Learn" wrote in message ... Dave Brillant thanks "Dave F" wrote: 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. "Wanna Learn" wrote: 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Same column Percent and Currency
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" wrote: 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! ================================================== === "Wanna Learn" wrote in message ... Dave Brillant thanks "Dave F" wrote: 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. "Wanna Learn" wrote: 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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Same column Percent and Currency
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! ================================================== === "Wanna Learn" wrote in message ... 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" wrote: 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! ================================================== === "Wanna Learn" wrote in message ... Dave Brillant thanks "Dave F" wrote: 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. "Wanna Learn" wrote: 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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Same column Percent and Currency
RagDyeR Thanks again I see my mistake I was entering currency numbers
with decimal. thanks for your help. this is brillant ! "RagDyeR" wrote: 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! ================================================== === "Wanna Learn" wrote in message ... 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" wrote: 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! ================================================== === "Wanna Learn" wrote in message ... Dave Brillant thanks "Dave F" wrote: 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. "Wanna Learn" wrote: 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 |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Same column Percent and Currency
You're welcome, and thanks for the feed-back.
-- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Wanna Learn" wrote in message ... RagDyeR Thanks again I see my mistake I was entering currency numbers with decimal. thanks for your help. this is brillant ! "RagDyeR" wrote: 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! ================================================== === "Wanna Learn" wrote in message ... 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" wrote: 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! ================================================== === "Wanna Learn" wrote in message ... Dave Brillant thanks "Dave F" wrote: 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. "Wanna Learn" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMPRODUCT Help | Excel Worksheet Functions | |||
Currency, Percent and Comma Style buttons | Excel Worksheet Functions | |||
Calculating on alphabetic cell content | New Users to Excel |