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