rounding problem need accuracy when using V Lookup
In the past I was able down load a number from a data file (credit card transaction numbers for internal audit part of my job) I would have to change the number to a value for the vlookup to work properly. 15 character eg 999563256923654 would be translated to come out as 9.99563E+14 WHEN CONVERTED TO A VALUE. ... 6 May 2010 08:33
Time format 1500 become 15:00
Pls help me. I want to tape 1500 on A1 and A1 edit 15:00 Thanks for your answer ... 6 May 2010 19:52
Position screen at end of macro
So far, at the end of a macro I've been sending the cursor across to various columns and back to position the screen. Itys a bit clumsy, and of course when you work between different sized computer monitors it doesn't work the same. Is there a quick way to position a partcular cell at top left of screen - an... 3 Jun 2010 02:25
Opening Excel 2007 file with 2003?
What happens if a user with Excel 2003 opens an Excel 2007 file that has more than the max number of columns as permitted by 2003? (up to column IV) Do they just not see the extra columns, or can't they open it in the first place? Al ... 6 May 2010 18:45
permenently set options of the 'find' comand to look 4 values
I have spreadsheets that have formulas in them and each time I want to find the values I need to change it in the options. I want the find function to always look for values ... 6 May 2010 08:33
Unprotecting what Excel says is unprotected ???
I've just had a read of my PDF "How to do everything with Microsoft Office Excel 2003" by Guy Hart-Davis, and in the section about security, it suggested I try Tools - Options - Security and remove the "password to modify" password ... .... naaaaah, that sounds way too obviously simple ........... Thats Guy... 6 May 2010 03:07
Pivot from all sheets
Hi, Can anybody help me. I have 25 sheets with same no of column and in the same sequence. I need to make pivot using column A, B , and Cas range taking all the data from 25 sheets...if copy all the data from 25 sheets, paste in a single sheet and make pivot then it takes a long time and more over some times t... 6 May 2010 02:02
File set up query.
Can i set up an excel file to open automatically on pc start up? ... 6 May 2010 02:02
In excel worksheet comma seperator is based on 1000s . How can i change this to 100 sperator eg: Nos One Lakh is displaying as 100,000.00 but one lakh has to be displayed as 1,00,000. ... 6 May 2010 02:02
Copy and paste an image
I am trying to copy and paste a entire screen into Excel 2007. I tried using Alt and Print Screen and then paste it into Excel but it does not work. Any suggestions of what I am doing incorrect? Thanks, Bill ... 6 May 2010 02:02