Search results for query: *

Hi all, I have an excel file that is password protected. It now will not open after the password is entered and it comes up with the message "File not found" I would appreciate any help as the file contains personal finance information. The backup has the same problem. Thanks Ross

Hey Guys, It is Monday. When I went back to the user he informed me that he wanted to actually cut the last three digits and round. I ended up using #,###, and this solved his problem. Thanks for the help Ross

Thanks Zathras, I knew it had to be simple. Ross

Hi all, This should be simple, but I can't figure it out. What I want to do is have the cells formatted so when I type in a number it is automatically rounded to thousands. ie. Type in 10,234,987 and the cell result is 10,234,000 Thanks in advance Ross

When I paste photos into my Paradox tables they always increase in size from 4-18kb to 1mb+. I have tried using jpg,gif, and bmp files but they always end up the same.I have 300 plus ID photos to insert but at the size they are I will end up with a 600mb+ file. any suggestions!

Thanks Lance, saves us reinventing the wheel. Phil

We are using Borland BDE 5.01 to access Pardox tables of around 200,000 records. The applications are written in Paradox PAL and Delphi. Can anyone help with ideas on optomising the BDE system parameters, like MAXBUFSIZE and MEMSIZE ? Thanks in advance. Phil

Ken, I have this working with two extra columns (they can be hiden if necessary)and the formula below: In this example there is a column between the two sets of numbers (5 columns in total) In the fourth column: =IF(AND(A1>=$E$1,A1<=$E$3),B1,0) The $E$1 & $E$3 are referencing the dates in...

To anyone who can help. In excel I have 13 columns of numbers from which I need to select a row at a time, copy that row to another location which gives a result. That result then needs to be copied (value only) to a location next to the original selection. I then need to select the next row...