Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
guatdoc
 
Posts: n/a
Default how to apply one function to an entire column of numbers

I have a column of numbers in one currency that I need to convert into
another currency by dividing each cell in the column by the same integer. How
do I do a batch conversion?
  #2   Report Post  
Anne Troy
 
Posts: n/a
Default how to apply one function to an entire column of numbers

Try this:
http://www.officearticles.com/excel/...worksheets.htm
************
Anne Troy
www.OfficeArticles.com

"guatdoc" wrote in message
...
I have a column of numbers in one currency that I need to convert into
another currency by dividing each cell in the column by the same integer.
How
do I do a batch conversion?



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 replace column letter in refferences with a function using the old column letter? Dmitry Kopnichev Links and Linking in Excel 6 October 13th 05 09:09 AM
Fill the entire column with a function [email protected] Excel Discussion (Misc queries) 1 September 29th 05 11:26 AM
formulas to numbers Steve New Users to Excel 2 September 16th 05 12:07 AM
up to 7 functions? ALex Excel Worksheet Functions 10 April 12th 05 06:42 PM
I cannot get a column of numbers to sum, why? HHG Excel Discussion (Misc queries) 8 February 8th 05 12:55 PM


All times are GMT +1. The time now is 06:37 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"