| 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 |
| 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) | |||
Threaded Mode
