Help! I have some data that I am importing into Excel. I have a range
of cells that is 11 rows x 2 columns. What I need to do is simple. I
need to multiply each cell in this range by 60 without going in to each
one and typing =PRODUCT(60*........). Anybody got any suggestions?
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/
Put 60 in an empty cell, copy it, select the 11 x 2 range and
do edit>paste special and select multiply
i have a sheet that consists of 7 coloums and unlimited rows, i need to
colour a group of numbers so that when they appear they turn a certain
colour. tried to do it in conditional but this only allows me to use 3.
any help would be appreiciated.
jkf schreef in news:I_tip.email@example.com
> i have a sheet that consists of 7 coloums and unlimited rows, i need
> to colour a group of numbers so that when they appear they turn a
> certain colour. tried to do it in conditional but this only allows me
> to use 3. any help would be appreiciated.
Here...Change row colur
I have a large spredsheet that I want to make easier to read.
In column B you can type in x or a. What I want is that if B15 changes to a
the whole row should became grey. This should be the case for the whole sheet.
Do anyone know how to do this?
Look at conditional formatting in excel's help.
> I have a large spredsheet that I want to make easier to read.
> In column B you can type in x or a. What I want is that if B15 changes to a
> the whole row sho...Phone number format
When I enter a phone number for a contact, the phone number ends up
with just a line under it. Like, if I enter 8074567891 I get
8074567891 underlined. Outlook used to format it to (807)-456-7891,
I don't know what I did, or what something did, but is there a way to
define a default format for phone numbers?
Appreciate any help. I am using Outlook 2003 with Windows XP, all
latest updates from MS applied.
Try leaving spaces 807 456 0000 and it should format it. If you don't have
the spaces it doesn't recognize it as a phone #.
...In Excel how can I add 90 every value in a row or column?
Todd, put 90 in a cell, copy the cell, select the cells you want to add 90
to, edit, paste special, check add OK
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
"Todd" <Todd@discussions.microsoft.com> wrote in message
> Any suggestions?
...Hiding a row in CListCtrl
This has been asked on a few different posts, but I hope I can add a
different spin to the question.
I need to hide a row in CListCtrl rather than delete/insert a row. I
realize hiding a row isn't supported, but has anybody successfully
simulated a hidden row, such as setting the height of a row to zero?
> I need to hide a row in CListCtrl rather than delete/insert a row. I
> realize hiding a row isn't supported, but has anybody successfully
> simulated a hidden row, such as setting the height of a row to zero?
Why not "sim...How do I create a cell that is self numbering with Excel
I am trying to create a control form that has three cells that need to be
self numbering. These numbers would increase by just one number. I do not
want anyone to have to change these numbers but rather the form to do this.
Why don’t you write a formula i.e in the cell A3 (=A2+1) and drag it down
then protect the column A using the option Tools / Protection …. / Protect
That will not permit any one to change the data in Column A
> I am trying to create a control form that has three cells that need to be...Multiplying two columns
How do I multiply column A (length) by column B (width)? All I want is a new column C (area) where the cells correspond to what I just multiplied if one were to look from left to right. A x B = C. I can do it for two numbers but not whole columns....
In (eg) C1
Point to bottom right corner until you see the plus
To get the sum of all A*B you can use:
Norman Harker MVP (Excel)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
...Filter by Row?
I am working with a somewhat convoluted workbook of personnel
records. The Personnel are listed by columns and the categories are
by row. I=92m having trouble filtering and I believe it is because of
the data arrangement. Often I need to filter on different categories.
For example =93Position/Title=94 so that I can look at all of a particular
type of employee. When filtering is enabled, the selection arrows are
only available on the column headings, not the row headings. Is there
a way to get around this limitation? Unfortunately I cannot change
the orientation of the data.
Rober...Unique Random Number Generator
I'm looking for a macro that will generate a unique Random number between
1-2000. The random aspect is obviously not the problem, the unique
requirement is whats got me stumped. Thanks Tom.
What about using RANDBETWEEN function?
It is not a macro but it appears to suit your need.
Bottom is the smallest integer RANDBETWEEN will return.
Top is the largest integer RANDBETWEEN will return.
Formula Description (Result)
=RANDBETWEEN(1,100) ...How to multiply time?
I'm trying to do a quick and dirty time sheet where all I enter is hours
worked and hourly rate.
If the hours were whole numbers this would be simple but if someone works 40
hours 28 minutes
That would be 40.4666666...
I guess one way would be to have the whole numbers in one column and the
partials in another and then add them both once I convert the partials from
60th's to 100ths
A1 = total time in [h]:mm format as a true Excel time value
B1 = hourly rate
You will probably want to round the result to 2 decimal places:
=ROUND(A...Trying to determine what cells within a Row have a 0 (zero) value
I'm new to programming and am trying to create code to read a row
cells 5 - 24 and determine what cell has a 0 value (The row is always
sorted by descending values). So I want to read each cell starting
with C5 through the end of the range C24, and stop when it gets the
first 0 value. Here is my code so far. I don't get any errors, but
it deos not seem to be doing anything. All Help is appreceated!
Dim StartRange As Variant
Dim EndRange As Variant
Dim EndRangeAdress As Variant
Range("...number appears as #.#####E+14
I have downloaded a csv from my fedex.com account that has tracking numbers
for packages, but unfortunately it only displays the number in this format
It should be a 15 digit number If I click the record, I will see the actual
number in the insert function box. How can I get it to show the whole
number? It's not a width problem because I've widened the column to
accomodate more than 15 char.
Change the format:
Number (0 decimal places and no 1000 separator)
> I have downloaded a csv from my fedex.com account that has tra...Hyperlink is not updated after inserting rows.
Suppose I created a hyperlink that points to cell A10.
If I insert a new row between rows 9 and 10, my "old" A10
cell now is A11.
BUT, my hyperlink still points to A10.
Is there any way to make it dinamically, it means, when I
insert a new row, all hyperlinks are automatic updated ?
Consider using the hyperlink function to create the links:
=HYPERLINK("#" & SUBSTITUTE(CELL("address",Sheet2!A4),LEFT
The a...number in system using arrivals and departures
Is there and easy way to figure out the total number of persons in a system if have access to the arrival and departure times. I have tried to use counts with if statements, but I keep getting the number 1. I know this is not correct. Is there any special macros or functions
you may provide some more details about your data. Could you post some
example rows (plain text - no attachments please) and describe your
> Is there and easy way to figure out the total number of persons in a
> system if have access...building a worksheet row by row
I hope somebody can assist.
My worksheet calculates rows of data, which I wish to slide into another
worksheet and secure; then change the original data, slide those results
under the first. Keep repeating.
Is there a way to do this without manually pasting values each time?
"Sliding" rows from one sheet to another would involve the use of VBA.
See Ron de Bruin's site for moving/copying rows to next available empty rows.
Gord Dibben Excel MVP
On Thu, 4 Nov 2004 14:04:03 -0800, "DaveButcher"
if I have two columns A and B. A is filled with numbers that I want to
multiply by the same number and have that total fill B. But I want also to be
able to change the number and have all the totals update....how?
Can't be done (without a lot of programming). This is not how Excel is
designed. Spreadsheets have lots of columns. Simply put the result of the
multiplication in column C.
"wineforyou" <firstname.lastname@example.org> wrote in message
> if I have two columns A a...Number format in queries
Hopefully this is easy.
Does anyone know if it is possible to change the default number format for
number fields to "standard" (or any other format). I'm getting very tired of
going into properties all the time to flip the setting so that large numbers
are actually readable.
"Tom Telford" <TomTelford@discussions.microsoft.com> wrote in message
> Does anyone know if it is possible to change the default number format for
> number fields to "standard" (or any other f...how to find several amounts in a list that add up to a certain total?
I'm comparing big lists of derlivery notes
Is it possible to find cells in a big list that add up to a certain
Lets say I'm looking for a difference of 843.10. Can xls find any
combination of cells in a certain column of a big list to come to that
Any help would be highly appreciated - rgds, Andy
...Why does it multiply my 'sum' by 17?
Ok. I am working with a select queury and all I am trying to do is sum two
numbers in a column together that share the same 'queue'.
For some reason it's adding the two numbers and then multiplying by 17 for
Any ideas? Thanks for your help.
Post your SQL.
Build a little - Test a little
"Love Buzz" wrote:
> Ok. I am working with a select queury and all I am trying to do is sum two
> numbers in a column together that share the same 'queue'.
> For some reason it's adding the two numbers and then mul...Multiplier
I'm creating a spreadsheet for work, and I would like to use one multiplier
throughtout the entire spreadsheet, instead of having to enter repeatedly
putting in the same forumula over and over again.. the cells contain
different numbers but the multiplier will always be the same.
Enter the multiplier in an unused cell then highlight the range that you
want to update and the right-click and select Paste Special, (or select Edit
> Paste Special), then select Multiply
In Perth, the ancient capital of Scotland
and the crowning place of kings
email@example.com...Formula to auto-assign sequential number
I have a spreadsheet that lists parts and associated quantities. The user
will be able to add and delete parts from the list. I am looking for a
formula that will automatically assign a “dash number” to the parts. The dash
numbers will be in numerical order and skip any part that has a quantity of
Original Part Qty Automatically assigned “dash number”
The user may change the quantities on the list therefore I need to formula
that will automatically recalculate the “dash number” based on the users
input. For example:
Revised Part Qty Automat...excel dividing all numbers by 10,000
excel 2002 was dividing all numbers by 10000 even though
the data type was general. i tried changing the data
types but to no avail. it pissed me off enough to go and
wipe out the registry settings for excel and the problem
was fixed. what i want to know was what happened? this
happened on my sister's computer. did she activate some
silly formatting? thanks
She or someone else did, look under tools>options>edit
and uncheck [fixed decimal places] which I assume was set to 4
"Nhat" <firstname.lastname@example.org> wrote in message
news:2765901c38...How to assign index number
I need to assign an index number to each record. These
index numbers should be in a new column. What can I do?
In the first row you could put:
and fill down. If first record is not in row 1, but say,
row 5, change it to:
Now copy the column and go to Edit > Paste Special >
>I need to assign an index number to each record. These
>index numbers should be in a new column. What can I do?
I got it. Thank you very m...How do I enter page numbers such as "Pg # of #"?
I have a workbook that has a list with peripheral data. I have set up
everything but I can't seem to get the page numbers to print out the way I've
described in the subject field.
Go to page setup, Header/footer, custom footer, the 2nd selection is the
page number, choose where to put it, left, center or right
> I have a workbook that has a list with peripheral data. I have set up
> everything but I can't seem to get the page numbers to print out the way I've
> described in the subject field.
On 3/12/2010 10:29 ...