Forum home » Delegate support and help forum » Microsoft Excel Training and help » Recommended/best practice in formatting
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Recommended/best practice in formatting
Resolved · Low Priority · Version 2007
Reply Thu 9 Sep 2010, 15:55Delegate Edward said...
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.
For upcoming training course dates see: Pricing & availability
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
Reply Fri 10 Sep 2010, 09:31Delegate Edward said...
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
Fri 17 Sep 2010: Automatically marked as resolved.
|