| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Concantenant and % but shows actual number
I have a spread sheet with a large number of categories and a corresponding %.
I want to concantenant the heading and the attached % in an additional column. So far so good but when I concantenant the % any value other than 0% reverts to the full number below. So 5% displays as .05687899797897 (or what ever number sits underneath) Is there a way of getting it to display as a percentage. Ultimately I want to import it to Visio (so the same problem may occur!). Any help appreciated Hager |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Concantenant and % but shows actual number
as an example...assuming a1 has your percentage and a2 has your heading,
would something like this work for you... =A2&" "&(ROUND(A1,2))*100&" %" "Hager" wrote: I have a spread sheet with a large number of categories and a corresponding %. I want to concantenant the heading and the attached % in an additional column. So far so good but when I concantenant the % any value other than 0% reverts to the full number below. So 5% displays as .05687899797897 (or what ever number sits underneath) Is there a way of getting it to display as a percentage. Ultimately I want to import it to Visio (so the same problem may occur!). Any help appreciated Hager |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Concantenant and % but shows actual number
Hager -
In your concatenate, use the TEXT function to format the percent any way you want. For example, if you want no decimal places, use this: TEXT(B4,"0%") -- Daryl S "Hager" wrote: I have a spread sheet with a large number of categories and a corresponding %. I want to concantenant the heading and the attached % in an additional column. So far so good but when I concantenant the % any value other than 0% reverts to the full number below. So 5% displays as .05687899797897 (or what ever number sits underneath) Is there a way of getting it to display as a percentage. Ultimately I want to import it to Visio (so the same problem may occur!). Any help appreciated Hager |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Show actual values added instead of cell references? (=A1+A4 shows as=10+2 in cell) | Excel Discussion (Misc queries) | |||
| Date shows "00:00.0" rather than actual value | Excel Discussion (Misc queries) | |||
| Excel link shows zero value instead of actual amt | Excel Discussion (Misc queries) | |||
| Numbers appear as ##### instead of the actual number, how to fix? | New Users to Excel | |||
| How do i Use actual number displayed? | Excel Worksheet Functions | |||
Linear Mode
