LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 13
Default Percent Format without Percent Sign

I know this is the programming newsgroup, but there is no formatting newsgroup, so this will have to do. Is there a way to format a cell so that the value is multiplied by 100, but does not show a percent sign? I can't seem to find a way, but maybe somone knows a trick, like how to put a backspace character after the percent sign in the custom number format

I have an alternate, not as nice way of dealing with this, but I'd really like to be able to do it with formats

Thanks

James
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Value Axis - How to remove percent sign without changing values? [email protected] Charts and Charting in Excel 21 April 2nd 23 07:24 PM
On a column chart, how do you put a percent sign on the top most . JudyF Charts and Charting in Excel 2 January 14th 08 05:14 AM
Formatting a number to look like a Percent without a percent sign David Iacoponi Excel Discussion (Misc queries) 2 September 15th 05 06:35 PM
How do I format a negative percent? Hawk186 Excel Discussion (Misc queries) 1 February 10th 05 09:02 PM
Percent Format Todd Huttenstine[_2_] Excel Programming 2 November 21st 03 03:00 AM


All times are GMT +1. The time now is 11:46 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"