Decimal when it´s necessary

[darkxer0x]

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).

 

[RagDyeR]

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!
=====================================================

in message
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]

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...)

 

[RagDyeR]

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!
=====================================================

in message
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]

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...)