Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
TomBk
 
Posts: n/a
Default How add "%" sign to a list of numbers?

How can I add a percentage sign to an entire list of numbers in one
operation?

Thanks. Cheers.

  #2   Report Post  
Posted to microsoft.public.excel.misc
Max
 
Posts: n/a
Default How add "%" sign to a list of numbers?

You've got some responses in your next, "duplicate" posting <g
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dav
 
Posts: n/a
Default How add "%" sign to a list of numbers?


Well if the list of numbers is a continuous range you can do it in 3
operations!
Firstly % is just a format, but the number needs to be 100 times
smaller

so type 100 in one cell, select this cell and then select the range you
want to chance and choose paste special operation divide.

Then format your cell as a perentage

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=545749

Reply
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
how to extract unique numbers once from a list of repeated numbers? [email protected] Excel Discussion (Misc queries) 2 May 2nd 06 04:17 PM
Comparing numbers, ignoring sign steev_jd Excel Discussion (Misc queries) 3 April 18th 06 10:44 AM
find sum in list of of numbers Jim Thomlinson New Users to Excel 3 January 4th 06 09:58 PM
find sum in list of of numbers Jim Thomlinson Excel Discussion (Misc queries) 5 January 4th 06 07:07 PM
How do I create a list of sequential numbers using Excel or Acces. Clueless Excel Discussion (Misc queries) 1 April 5th 05 03:08 PM


All times are GMT +1. The time now is 03:17 AM.

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

About Us

"It's about Microsoft Excel"