Decimal when it´s necessary

From: darkxer0x <darkxer0x.2a9muo_1151755802.6739_at_excelforum-nospam.com>
Date: Sat, 1 Jul 2006 07:10:02 -0500

Hi.
I write integers with currency like 5 €, 30€. But sometimes I have to write decimals, like 5,5€ 34,3 €. The problem is that all cells must have the same format, so when I configure with 1 decimal, excel writes 5,0 €, and I want it to write 5 €, without the decimal 0. And if I configure without decimals, if I write 5,6 €, excel writes 6 € (it rounds up).

-- 
darkxer0x
------------------------------------------------------------------------
darkxer0x's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=35967
View this thread: http://www.excelforum.com/showthread.php?threadid=557564

Received on Sat Jul 01 2006 - 05:10:02 PDT