Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Percentages and formatting cells
Hi all
When I enter a figure into a cell and click onto the % icon, it doesn't simply add a % sign at the end of the figure, it changes it into something else altogether - what is it doing? Also, if I then delete the figure and enter another one, it does just put the % at the end of the figure. Can anybody explain exactly what the icon is doing to the formattin of the cell? Thank you. Louise |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Percentages and formatting cells
Hi Louise
The % is a shortcut to format a cell as a percent, if you type 10 and click on the % icon excel will shows 1000% because it will multiple 10 by 100 (percent), to have 10% type 0.1 and click % icon when you format the cell as a percent all figures you type there will show as percent, change the format of the cell to general so fix it. -- hth regards from Brazil May the force be with you Marcelo ******************* "Louise" escreveu: Hi all When I enter a figure into a cell and click onto the % icon, it doesn't simply add a % sign at the end of the figure, it changes it into something else altogether - what is it doing? Also, if I then delete the figure and enter another one, it does just put the % at the end of the figure. Can anybody explain exactly what the icon is doing to the formattin of the cell? Thank you. Louise |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help on a function with Conditional Formatting | Excel Worksheet Functions | |||
Nesting IF statements, Conditional Formatting | Excel Discussion (Misc queries) | |||
Percentages | Excel Discussion (Misc queries) | |||
Counting coloured cells | Excel Discussion (Misc queries) | |||
Calculate percentage based on cells with conditional formatting | New Users to Excel |