Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
convert number into a decimal
Hello I have a spreadsheet in column b there is a number when I try
to format the number to a percentange I get the wrong answer. example column B has a 5 the answer should be 5% . but when I format the cell for decimal I get 500.00% how do I correct this thanks column is formatted as general |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert dd:hr:mn:ss to Decimal number of hours | Excel Discussion (Misc queries) | |||
CONVERT HEXADECIMAL CELL TO DECIMAL NUMBER | Excel Worksheet Functions | |||
convert decimal number to time : convert 1,59 (minutes, dec) to m | Excel Discussion (Misc queries) | |||
How to convert a decimal number to a non-decimal number? | Excel Worksheet Functions | |||
how to convert total hours (HH:MM) into decimal number | Excel Worksheet Functions |