Search results for query: *

Type in Username and password then click on properties and Comfirm the contoll database and Company is ok the click ok This happens with us when we switch companies

Try typing 100

Hi There Try =IF(A1=&quot;&quot;,&quot;&quot;,IF(A1<100,A1+10+(A1*0.15),IF(A1<200,A1+20+(A1*0.23),IF(A1<300,A1+30+(A1*0.35))))) First if brings back blank for blank (Use 0 for calculation field) then you can get 6 more IF functions in (Can do an extra 7 if you use a another reference field.

goto> my computer>Tools>Folder Options >file Type search for the .xls extention and double check if Excel is selected as program file, (Check under the advance tab that the excel.exe location is correct)

Have you got your cell format on general?

Another good trick is to add a shortcut to your notepad in the sent to folder. So you open a file with Notepad, (Instead of going through the 'open with'option

You could use a left function in the column next to the field=left('cell',23). or set that procedure up as a macro

Hi, You could try combining the two columns eg vlookup((A1&b1),'sheet2C:D,2,false) Where C:D is a combined lookup table If this does not work could you give an example of the lookup result?

You could save the Word file as an text file and import it in Excel (through File> Open> [files of type] '*.txt'

Why not try to Record it as a macro, Compare that code to yours,

Use the formula round(cell,&quot;# of Digits&quot;) Otherwise format cells tools options Calculation tab Precesion as displayd note this is a permanent solution, no roll back

AR Maintenance Set Up Automatic Numbering

Have you tried Running a combination of a Pivot Table and Vlookup?

Try Copy the cell and pres <shif><CTRL><down Arrow> then paste (<CTRL> <V>) then <CTRL> <Down Arrow>, to go to the next emptie field

Have you checked the properties from the text file, is the read only file ticked) if so untick read only and try again

Highlight Collumn, select count functions from bottom right tool menu.

Have you tried to add the 'B' in the 'Automatic Numbering' option?