Access Query
Now we have a table created we can start to use it I want to know which customer has the […]
Now we have a table created we can start to use it I want to know which customer has the […]
This example is a simple Address Book Table AddressBook Query Addresses Form Addresses It has been kept very simple to
Excel 2000-2003 Go to the start of your Spreadsheet Click \”View\” (menu bar at the top of the page) –>
In the cell enter \”=proper(value)\” This will display the value as mixed case e.g \”mr peter conway\” or \”MR PETER
Excel correct circular reference Click the Formulas Tab Click Error Checking (small yellow diamond with a Red Exclamation Mark)
To make a Macro available to all your Excel Spreadsheets save it in the following:- Early Versions of Office Loaded
I am asked this many times, so here is a sample. 1. How can an excel spreadsheet lookup a value
Why do the columns in my Excel spreadsheet display hashes? Sometimes when displaying numbers in an Excel spreadsheet the number
Useful formula to display all text after the last full stop =RIGHT(A1, LEN(A1)-(FIND(\”#\”,SUBSTITUTE(A1,\”.\”,\”#\”,LEN(A1)-LEN(SUBSTITUTE(A1,\”.\”,\”\”)))))) How does this work? Let\’s look at
How to change the color of a cell based on the value of another cell This example changes the color