This has probably been posted heaps of times over the years but the solution continues to elude me. I have amended the currency format in both the UnitPrice field of OrderDetails and Products to Currency £345 (etc) which at first looked like I had sorted it but then in any calculated fields it reverts back to $ (Grrr)
At first i thought it was my Regional Settings on my PC causing the error but that is clearly set to GBP (£)
Is there a macro or VB Code or something in Northwind controlling this and causing this to happen?
Any help would be greatly appreciated.
At first i thought it was my Regional Settings on my PC causing the error but that is clearly set to GBP (£)
Is there a macro or VB Code or something in Northwind controlling this and causing this to happen?
Any help would be greatly appreciated.