 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / May 2008Percentages and whole numbers
Does anyone know how to convert numbers that get imported as percentages converted to whole numbers? Ex. 100% to 100, 80% to 80 Thansk for any help. One way. Right click the cells where you hve the percentages go to Format Cells > Number tab > select Number from the list. This will convert 100% into 1 and 80% into .8 Now type 100 in any blank cell> copy that cell> again select all the cells> right click>paste special>multiply. Does that help? > Does anyone know how to convert numbers that get imported as percentages > converted to whole numbers? > > Ex. 100% to 100, 80% to 80 > > Thansk for any help. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.