Excel 97 - Formatting Cells with Euro Currency

  NadineCoyleRocks 09:47 07 May 03

I was wondering if I could get some advice.

I am currently looking for a patch or add-on for Microsoft Excel 97 and the ability to be able to format cells with the Euro currency symbol. I did download an add-on from an Office website that added the euro symbol to the toolbar in Excel. However when using this it sets the decimal places to 2, if you change this through format>cells you loose your euro symbol. Obviously this isn't ideal because you can’t have one or no decimal places using the euro symbol. The only other way around this is to individually type the euro symbol in each cell.

Can anyone help????

Thanks in advance

  harristweed 10:08 07 May 03

I don't have exel 97 to try this but....

Go To format / cells then select custom and 'build' the euro format you require!

  VoG™ 10:15 07 May 03

If you click on the toolbar buttons to increase or decrease the decimal places, the € formatting "sticks".

  NadineCoyleRocks 10:18 07 May 03

You know, your completely right! Can't believe i missed that! Cheers!

  Taran 10:26 07 May 03

To type or insert the Euro symbol, hold down the Alt key, and type 0128 on the numeric keypad.

Formatting can be done using normal means and you can choose how many decimal places you want, or not as the case may be.

If you want a formula to convert any other currency to Euro, it depends very much on the exchange rate of the day.

Everything you even wanted to know about the Euro in tandem with MS Office is here:

click here

This thread is now locked and can not be replied to.

Amazon Fire HD 8 review: A brilliant combination of function and value – with one massive caveat

1995-2015: How technology has changed the world in 20 years

How to create an introvert-friendly workplace

Apple Watch 2 review | Apple Watch Series 2 review: New Apple Watch is faster, brighter, water-resit…