huge

Hi, I am looking to convert large 18 digit (Product Serial Numbers - Electronic Serial Numbers) numbers to its equivalent Hexadecimal numbers. Since my number is huge, I am getting #NUM ! error when I use DEC2HEX function. Can anyone please suggest me how do I do that in Excel? My data looks...

hi, I have huge data in 2 Excel workbooks, i have to fetch data from workbook1 to workbook2. Both files are on shared drive. i tried to use vlookup to fetch data from Worbook1 to Workbook2 but due to having huge data(round about 5000 raws, 50 to 60 columns ), Vlookup does not get refresh...

Dear Sir I need to move column under one column that fast way I can with our cut past because I have huge date In the picture below you can see the sample

Hello All, I have created a little bit of code that opens, calculates and resaves a few reports. These newly calculated wbs are then saved to a communial network drive. as .xlsb. All easy up to now, the machine i was using to do this, was on 2003. I am using 2007 to create all macros. I...

I just finished up a workbook with 28 sheets. There are 4 userforms, 2 of which are called by 12 of the sheets, and the other 2 by 1 sheet. In addition there is code added on 12 sheets to sort, copy and paste to other sheets. There is a fair amount of code, but not any more than similar...

Hi All, I am having a huge data like below <?xml version="1.0" encoding="UTF-8"?> <!--IMPORTPARAMS This inputs the options and inputs required for import operation --> <!DOCTYPE IMPORTPARAMS SYSTEM "impcntl.dtd"> <!--IMPORTPARAMS This inputs the options and inputs required for import...

Hi All, I am having a huge data like below <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE IMPORTPARAMS SYSTEM "impcntl.dtd"> <!--IMPORTPARAMS This inputs the options and inputs required for import operation --> Every starting < and ending > is a new line How to store in Excel with...

:eeek: I have a HUGE spreadsheet that lists every transaction ever done by my company since 2000 (31000+ line items). I have been asked to find out the minimum and maximum price for each part # repaired. Many of them have been repaired more than once and many have a dollar amount of $0.00 which...