If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Got me stumped
I have an Excel Report that was generated by ODBC. I was
asked to customize the report so that company numbers on one sheet would look up into another sheet and find the company name. No problem, simple Lookup. However, when I double checked to make sure that the names pulled in correctly, I noticed that not all of them pulled over correctly. For example, Company number two did not pull over the name of company number two, but number 20. That made me realize that it was looking in Alpha Numeric and not numeric. I then noticed that the alignment of the numbers was wrong. I tried changing the format of the numbers to General, number and several other options, but to no avial. I then copied the cells with number to Word. Copied, pasted special with no formatting, then pulled them back into Word and guess what! It worked. But, this is way too much work for the accounting guys to do. I tried to write a macro, but it blew up on me. Is there a way I can fix this in Excel??? |
#2
|
|||
|
|||
Got me stumped
Hi
To change a column of text to numbers, copy an empty unused cell. Select the column and Edit / Paste Special / Add Andy. wrote in message ... I have an Excel Report that was generated by ODBC. I was asked to customize the report so that company numbers on one sheet would look up into another sheet and find the company name. No problem, simple Lookup. However, when I double checked to make sure that the names pulled in correctly, I noticed that not all of them pulled over correctly. For example, Company number two did not pull over the name of company number two, but number 20. That made me realize that it was looking in Alpha Numeric and not numeric. I then noticed that the alignment of the numbers was wrong. I tried changing the format of the numbers to General, number and several other options, but to no avial. I then copied the cells with number to Word. Copied, pasted special with no formatting, then pulled them back into Word and guess what! It worked. But, this is way too much work for the accounting guys to do. I tried to write a macro, but it blew up on me. Is there a way I can fix this in Excel??? |
#3
|
|||
|
|||
Got me stumped
You are amazing! I don't know how you knew that, but it
worked like a charm! Thanks a bunch! -----Original Message----- Hi To change a column of text to numbers, copy an empty unused cell. Select the column and Edit / Paste Special / Add Andy. wrote in message ... I have an Excel Report that was generated by ODBC. I was asked to customize the report so that company numbers on one sheet would look up into another sheet and find the company name. No problem, simple Lookup. However, when I double checked to make sure that the names pulled in correctly, I noticed that not all of them pulled over correctly. For example, Company number two did not pull over the name of company number two, but number 20. That made me realize that it was looking in Alpha Numeric and not numeric. I then noticed that the alignment of the numbers was wrong. I tried changing the format of the numbers to General, number and several other options, but to no avial. I then copied the cells with number to Word. Copied, pasted special with no formatting, then pulled them back into Word and guess what! It worked. But, this is way too much work for the accounting guys to do. I tried to write a macro, but it blew up on me. Is there a way I can fix this in Excel??? . |
Thread Tools | |
Display Modes | |
|
|