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


--
Paul Sheppard


------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=568719