Hi,
I am a newbie and am operating Excel 2003.
As a practice session I am trying to calculate interest rate charge for a period. I noticed that the Basis (month/year basis) of the day count could be changed and hence I was quoted the following table:

0 or omitted US (NASD) 30/360
1 Actual/Actual
2 Actual/360
3 Actual/365
4 European 30/360

Since I am located in Europe I would like to change the current format to Basis 4 - European 30/360

How can this be done?
If this could be done would it affect the whole workbook or would one have to change and reformat each cell to take into account the above mentioned modification?

Any help will be greatly appreciated (even to other links were this problem has been tackled)

Thanking you in advance for your help.