Edward has attended:
Excel Advanced course
Recommended/best practice in formatting
On the course I remember seeing some best practice in terms of formatting cells: Data input, a certain format, Returning results, a certain format etc. I cannot find it jnow. Do you have any idea where I might find it? Thx.
RE: recommended/best practice in formatting
Hi Edward,
If its what Im thinking, then it was Data Validation. You'll find this in the Data Ribbon, Called Data Validation. From the dialog you can choose the type of format someone types in, this is in the drop menu called, Allow...
On the course we also used data validation to create a LIST, which creates a drop down menu on the sheet.
Hope that helps
Mark
RE: recommended/best practice in formatting
No. It was more to do with "Best practice" in general formatting. I may have seen it on the Office Website.
RE: recommended/best practice in formatting
Hi
It may be that best practice i mentioned was when typing dates, always type in raw format e.g. 1/3/10 and then apply the format through the format dialog (on the home ribbon).
When entering numbers, always type the decimal point, although you may not see it e.g. I type 23.50 or 23.00 but excel shows as 23.5 or 23
you then need to apply the formatting to say currency or number, 2 decimal places.
Don't need to type £ sign or % symbol, as they will be aplied automatically when you format.
Hope that helps
Mark
