Forum Statistics
- Forum Members:
- Total Threads:
- Total Posts: 5
There are 1 users currently browsing forums.
|
 |
07-01-2006, 08:10 AM
|
|
Registered User
|
|
Join Date: 01 Jul 2006
Posts: 5
|
|
|
Decimal when it´s necessary
Please Register to Remove these Ads
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 €
|
07-01-2006, 11:50 AM
|
|
|
|
Re: Decimal when it´s necessary
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
|
07-01-2006, 12:19 PM
|
|
Registered User
|
|
Join Date: 01 Jul 2006
Posts: 5
|
|
Hi.
It doesn´t work.
Quote:
|
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...)
|
07-01-2006, 12:50 PM
|
|
|
|
Re: Decimal when it´s necessary
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
|
07-05-2006, 05:49 AM
|
|
Registered User
|
|
Join Date: 01 Jul 2006
Posts: 5
|
|
|
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...)
|
|
|
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
|
|
|
| Thread Tools |
|
|
| Display Modes |
 Linear Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|
