P
Paul Sheppard
Hi I'm using excel 2000
Is there anyway to format cells such that I can enter values as Euros
and they automatically convert to £
eg If I enter 14.60 (Euros) it automatically displays as 10.00, my
conversion rate of 1.46 is constant throughout
Thanks in advance
ps I know I can do the copy paste special divide thing but the above
would be a much nicer solution
Is there anyway to format cells such that I can enter values as Euros
and they automatically convert to £
eg If I enter 14.60 (Euros) it automatically displays as 10.00, my
conversion rate of 1.46 is constant throughout
Thanks in advance
ps I know I can do the copy paste special divide thing but the above
would be a much nicer solution