It is possible for excel 2007 to generate numbers equal to a given number in cell.
Example in cell a1 i key in 146, i would like excel to give me a 5 or more numbers that is equal to 146 and place it to cell b1,c1,d1,e1,f1 so on.
i need a formula or even a vba code that would do that for me. i google it but i could not come up with the thing i want. Thnx for your help in advance. More power
So right now my VBA code Concatenates numbers from a variable into a cell to look like
x / y / z
However, x y and z do not match the number formats I want, as they'll say 5 or 6.1... I want it to display 2 decimal places.. how do I alter this in my VBA code with respect to the variable that is used to "insert" these concatenations? It concatenates to the end every time if that matters.
I am importing a list of values from a text file. Some of the values have the letter "E" embedded in the string. For example one of the imported values is "29875E100". Excel is automatically converting this into scentific notation. Is there a way to avoid this? Thanks.
Hi,
I have a work book that i need to check the version of excel that the user is using and the version number of the Excel Objects Library that excel is using.
Anyone any ideas??
Thanks
Jon
Hello,
I'm working on a spreadsheet to keep track of certain orders for some customers who want the info.
Right now i have a "Quantity" column which can range from 1 to 200, a "Part Number" column, and then a "Serial Number" column.
My problem:
"Quantity" will always be one cell
"Part Number" will always be one cell
"Serial Number" will need to be able to input as many serial numbers as there are quantities
I haven't figured out a way to enter in the serial number info in an organized way.
Is there some sort of pop-up VBA form i could use that when "serial number" cell is clicked it automatically asks for the proper number of serial numers and stores them somewhere as well?
Any ideas are appreciated. I've thought of some ways to do it, but nothing that makes me think "yes, that is the proper way to get this info and store it".
Thanks!
Hi
I need help with an Excel formula that would tell me if a number in a cell is greater or less than a number in another cell, within a difference of 15.
As an example, in the first two rows below the numbers are within 15 of each other, but the third row has a greater difference than 15.
30 40 Yes
50 45 Yes
100 80 No
Thanks
Dan
Hi
I need an help to create a macro to copy the value from number of excel sheets and paste it into another single excel sheet.
I have number files which are located in one location (ex: test, test1, test2, test3, test4)
I need to open each file and copy the item number which is in Cell B2 in the file named test.xls and paste it in the FINAL workbook and then again copy Total_Liab value in the tab named Calculations in the same workbook test.xls (total liability value) which is the last cell value in the column Q (example: Q51 in the Calculations sheet) Q51 and paste it next to the same item number in the FINAL workbook. Once it perform the action it should close the test.xls worksheet and then open the next test1.xls worksheet and should follow the same procedure as explained for the test.xls. Could you please help to create an macro
Hi, is there a way to lookup the largest number in a column but treating the negative number as a positive number?
Something like Max and Min but I want the largest absolute number between them.
Please see the attached example, in N41, i want it to show -10 instead of 5 and the depth beside it to show 22 instead of 8.
Thank you
I have access to publically available data that contains "ticks" in cells. I
can copy the data across to Excel and the ticks appear as pictures, all
neatly arranged in the appropriate cell. One tick - one picture, two ticks -
two pictures, there can be up to three ticks / pictures per cell. I can count
them and enter the number of ticks manually but this is time consuming and
liable to mistakes.
Any suggestions?
I have tried selecting cells that contain numerical entries but are being viewed as text and formating them as numbers but much of the time, this does not change how excel sees the entries.
There is nothing in the cell except numerical characters.
In this instance they came in from a code copying characters out of a numerical cell because some coding was changed from 4 digit to 5 digit and I'm trying to backtrack.
The Code that created the cells looks like this
Code:
=LEFT(A2,2)&RIGHT(A2,2)
where A2 has the numerical value 28058
and the result desired is the numerical value 2858.
Instead I'm getting a text value 2858, which doesn't surprise me but I can't figure out how to tell excel that this cell is a number.
Have 60 or so of these to do and I can do it by hand, but I've had this kind of problem in other settings and thought I'd ask since I'm on a roll.
Thanks
Brian
