| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Removing % sign, but keeping the formatting
I have data generated from another source that is all or mostly percents. I
need to remove the % signs before I put it into yet another program, but just removing the percent number format turns 56% into 0.56, which doesn't work for me either. I need it to display as just 56. Is there a way to keep the percent formatting without actually having the percent sign? Also, I need this to work for a large workbook with many, many worksheets. Thanks! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Removing % sign, but keeping the formatting
You could try this =SUBSTITUTE(G28,"%","")*100 VBA Noob -- VBA Noob ------------------------------------------------------------------------ VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833 View this thread: http://www.excelforum.com/showthread...hreadid=565900 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Removing % sign, but keeping the formatting
Or use Text to Columns. Tick the other and insert the % Or 56% *100 VBA Noob -- VBA Noob ------------------------------------------------------------------------ VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833 View this thread: http://www.excelforum.com/showthread...hreadid=565900 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying formulas to other cells. Keeping references w/o $ sign. | Excel Discussion (Misc queries) | |||
| Removing patterns but keeping fill colour | Excel Discussion (Misc queries) | |||
| Removing characters from a cell (keeping only numbers) 2 | Excel Discussion (Misc queries) | |||
| moving a pivot table graph and keeping the formatting | Charts and Charting in Excel | |||
| Combining Cells BUT Keeping source formatting | Excel Worksheet Functions | |||
Linear Mode
