Thread: Decimal when it´s necessary

Hi.
I write integers with currency like 5 €, 30€. But sometimes I have to write doubles, 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), and I want it to write 5,6 €

Would you accept the 5 *with* a decimal point *without* the zero ( 5. €)?

Custom format:

#.#€

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

"darkxer0x" <darkxer0x.2a9muo_1151755802.6739@excelforum-nospam.com> wrote
in message news:darkxer0x.2a9muo_1151755802.6739@excelforum-nospam.com...

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

Hi.

Custom format:#.#€

It doesn´t work.

Would you accept the 5 *with* a decimal point *without* the zero ( 5. €)?

Yes, it´s better 5. than 5.0

Custom format: #.##0 € --> 5 is 5 €; 7,8 is 8 €.
Custom format: #.##0,0 €, 5 is 5,0€; 7,8 is 7,8 €.
Is it possible a mix of them?? #.##0 € when number is an integer, #.##0,0 € when number is a double (Java can distinguish between integers and doubles, but I thinks excel not, excel only distinguish between number, text...)

I believe that your version of XL would need commas instead of my version
using periods.

Try it with commas:
#,#€

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

"darkxer0x" <darkxer0x.2a9yfb_1151770801.9626@excelforum-nospam.com> wrote
in message news:darkxer0x.2a9yfb_1151770801.9626@excelforum-nospam.com...

Hi.
> Custom format:#.#€
It doesn´t work.

> Would you accept the 5 *with* a decimal point *without* the zero ( 5.
> €)?
Yes, it´s better 5. than 5.0

Custom format: #.##0 € --> 5 is 5 €; 7,8 is 8 €.
Custom format: #.##0,0 €, 5 is 5,0€; 7,8 is 7,8 €.
Is it possible a mix of them?? #.##0 € when number is an integer,
#.##0,0 € when number is a double (Java can distinguish between
integers and doubles, but I thinks excel not, excel only distinguish
between number, text...)


--
darkxer0x
------------------------------------------------------------------------
darkxer0x's Profile:
http://www.excelforum.com/member.php...o&userid=35967
View this thread: http://www.excelforum.com/showthread...hreadid=557564

Well, I´ve just done it. It was really easy. In custom formato, General €
(I think the name is General, (the first option) because my excel is in spanish...)