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...o&userid=35967
View this thread: http://www.excelforum.com/showthread...hreadid=557564