| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Decimal when it´s necessary
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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" wrote 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 ------------------------------------------------------------------------ darkxer0x's Profile: http://www.excelforum.com/member.php...o&userid=35967 View this thread: http://www.excelforum.com/showthread...hreadid=557564 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Decimal when it´s necessary
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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" wrote 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 ------------------------------------------------------------------------ darkxer0x's Profile: http://www.excelforum.com/member.php...o&userid=35967 View this thread: http://www.excelforum.com/showthread...hreadid=557564 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Decimal when it´s necessary
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...) -- darkxer0x ------------------------------------------------------------------------ darkxer0x's Profile: http://www.excelforum.com/member.php...o&userid=35967 View this thread: http://www.excelforum.com/showthread...hreadid=557564 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula for: Format Decimal places? | Excel Discussion (Misc queries) | |||
| h:mm to decimal value | Excel Discussion (Misc queries) | |||
| Excel adds phantom decimal places: why? | Excel Discussion (Misc queries) | |||
| How do I override fixed decimal place settings in EXcel 2003? | Excel Worksheet Functions | |||
| decimal point override does not work | Excel Discussion (Misc queries) | |||
Linear Mode
