I have made a certificate in Word which takes values from Excel database.
Now there is a column which gives me percentage. I want only 2 place after decimal and I did this in Excel using "decrease decimal" button. But when Word fetches these values by mail merge, it gives several places after...
Hi,
I have made an excel file which contains a different supplier's information on each sheet, along with one of the categories approved, conditionally approved, conditionally rejected and rejected. Now I want one summary sheet to display a list of all the suppliers that are either approved or...
Hi,
I am making a sheet where there are 3 columns. Column A has 3 list items Contract, Under-warranty and Out-of-Waranty. Column B is for warranty certificate no. and Column C for expiry date of warranty.
If a person selects "Under-warranty" in A2 from the list, but does not enter a...