Prethodno rešenje je ok, ako ti 0 treba zbog računanja sumarne vrednosti.
Inače, za prikaz ti ne trebaju formule, koristi format ćelije. Vidi HELP >> custom number format
Ili, CTRL+1 >> FormatCells >> Custom >> Type:
Citat:
A number format can have up to four sections of code, separated by semicolons. These code sections define the format for positive numbers, negative numbers, zero values, and text, in that order.
<POSITIVE>;<NEGATIVE>;<ZERO>;<TEXT>
Da bi uvek prikazivao "0" za negativne, unesi "0" u oblast za negativne vrednosti:
na raspolaganju je 8 boja
Citat:
Specify colors To specify the color for a section of the format, type the name of one of the following eight colors enclosed in square brackets in the section. The color code must be the first item in the section.
[Black]
[Green]
[White]
[Blue]
[Magenta]
[Yellow]
[Cyan]
[Red]
Have you found helpful examples, solutions or ideas-in-work, please consider the
following:
• Citation of *actual page* you are going to using is welcome.
• Have you saw "Value Added" examples you are going to incorporate to your
profitable blog, daily job or any money making venture: How about online donation?
↗Ana & Vlade Divac Foundation
Hvala!