LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 38
Default how to get actual percentage format instead of 100 multiplied

Hi all€¦.

In excel I am have a simple problem with % number format.
If a number assigned to % symbol it is multiplied with 100 and giving %
symbol.
For example if we assign % symbol to 12, it shows 1200%. But I need it
only 12%.

I am usually works with comparison with percentages. If I apply % symbol to
any no. It gives
Multiplied by hundred and % symbol..

Plz help me in this problem..

Thanks
Narendra

 
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
APR - Annual Percentage Rate to Actual Interest Rate Safu Excel Worksheet Functions 9 May 18th 05 05:03 AM
Percentage format Randy New Users to Excel 2 May 11th 05 05:06 PM
time format multiplied by hours worked ? Brett Excel Worksheet Functions 2 January 11th 05 01:11 AM
copy conditional format as ACTUAL format Dana Zulager Excel Discussion (Misc queries) 7 December 7th 04 11:02 PM
Percentage format f16pilot Excel Worksheet Functions 3 October 29th 04 09:47 PM


All times are GMT +1. The time now is 12:55 PM.

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"