Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
deleting percentage sign
I want to delete the percentage sign (%) in a cell that is formulated for
mpg's. How do i do that so it shows MPG or nothing at all and still has a one decimal point answer such as 24.5 ?? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
deleting percentage sign
If one cell, click in it, go to Format/cells/Number and select Number from
the list. Then, pick 1 for decimal places. In the cell, I assume it has a formula. Let's say the formula is: =a2/a3 instead, enter =IF(A2/A3=0,"",a2/a3) "Milwpacker" wrote: I want to delete the percentage sign (%) in a cell that is formulated for mpg's. How do i do that so it shows MPG or nothing at all and still has a one decimal point answer such as 24.5 ?? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
deleting percentage sign
Sean... the formula you provided gives me nothing. When I change over to
just using a number in that cell it changes the number to look like .2 i want it to read like 24.5 or 24.5 mpg "Sean Timmons" wrote: If one cell, click in it, go to Format/cells/Number and select Number from the list. Then, pick 1 for decimal places. In the cell, I assume it has a formula. Let's say the formula is: =a2/a3 instead, enter =IF(A2/A3=0,"",a2/a3) "Milwpacker" wrote: I want to delete the percentage sign (%) in a cell that is formulated for mpg's. How do i do that so it shows MPG or nothing at all and still has a one decimal point answer such as 24.5 ?? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
deleting percentage sign
ok.. so you would need to * by 100.
=IF((A2/A3)*100=0,"",(a2/a3)*100) "Milwpacker" wrote: Sean... the formula you provided gives me nothing. When I change over to just using a number in that cell it changes the number to look like .2 i want it to read like 24.5 or 24.5 mpg "Sean Timmons" wrote: If one cell, click in it, go to Format/cells/Number and select Number from the list. Then, pick 1 for decimal places. In the cell, I assume it has a formula. Let's say the formula is: =a2/a3 instead, enter =IF(A2/A3=0,"",a2/a3) "Milwpacker" wrote: I want to delete the percentage sign (%) in a cell that is formulated for mpg's. How do i do that so it shows MPG or nothing at all and still has a one decimal point answer such as 24.5 ?? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
deleting percentage sign
Hi,
As Sean said you need to multiple by 100. In addition if you want to display it as 23.5 MPG then select the cell or range and choose Format, Cells, Number tab, Custom, and enter the following on the Type line #0.0 "MPG" -- Thanks, Shane Devenshire "Milwpacker" wrote: I want to delete the percentage sign (%) in a cell that is formulated for mpg's. How do i do that so it shows MPG or nothing at all and still has a one decimal point answer such as 24.5 ?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Getting a positive percentage to have a + sign | Excel Discussion (Misc queries) | |||
Displaying percentage sign in cell | Excel Worksheet Functions | |||
Percentage sign | Excel Discussion (Misc queries) | |||
Deleting a $ sign in Excel | Excel Discussion (Misc queries) | |||
How can I add a percentage sign to a cell with data validation | Excel Worksheet Functions |