2007/4/13, NoOp <[EMAIL PROTECTED]>:
On 04/13/2007 02:12 AM, Johnny Andersson wrote:
> 2007/4/12, NoOp <[EMAIL PROTECTED]>:
>>
>> On 04/12/2007 12:15 AM, Johnny Andersson wrote:
>>
>> >>
>> >
>> > If cell value = 0, then $0.00 will be shown in both cases, instead of
a
>> > blanc cell that the OP wanted (if I didn't misunderstand the whole
>> thing).
>> >
>> > Johnny Andersson
>> >
>>
>> Really? Then perhaps my spreadsheets are fooling me.
>>
>> Or maybe you unticked Display Cero Values (Tools â†' Options… â†'
> OpenOffice.org Calc â†' View â†' Display â†' Zero Values)?
>
> There MUST be a reason why my spreadsheets shows one thing and your show
> another thing, right? I tested that before writing, I really did.
>
> Just to make sure we are talking about the sme thing, I tested these in
the
> Format code field:
> "$"#,##0.00_);[RED]\("$"#,##0.00\)
> [$$-409]#,##0.00;[RED]-[$$-409]#,##0.00
>
> And to be even more sure, I will test it right now.
>
> The Zero Values checkbox is ticked.
> I now write 0 in A1 in a New spreadsheet.
> I right click and select Format cells. The Number tab is already
selected.
> Since my default language is Swedish, I select English (USA) in the
Language
> box.
> Now I copy and paste *"$"#,##0.00_);[RED]\("$"#,##0.00\)* directly into
the
> Format code field.
> The cell now shows *$0.00*.
>
> Now I do the same procedure once again, but this time with the *
> [$$-409]#,##0.00;[RED]-[$$-409]#,##0.00*.
> The cell now shows *$0.00*. The only difference was that the value was
moved
> slightly to the right, maybe 1 or 2 pixels on my screen.
>
> I will now try with *[$$-409]#,##0.00;[RED]-[$$-409]#,##0.00;@*. I will
copy
> it from here and paste it directly in the format code field, just like
in
> the other examples.
> The cell now shows nothing.
> I now enter *1* in the cell.
> The cell now shows *$1.00*.
>
> This is exactly the same thing as the format code *
> [>0][$$-409]#,##0.00;[<0][RED]-[$$-409]#,##0.00;@*, which by the way
does
> not work in Excel.
> *
Is the cell set for "Currency" or "Number"? Format|Cells|Number
"To get it to not show $0.00 the easiest way that I can recommend is get
rid of the currency formating altogether. Unless you are dealing with
mixed currencies just use number formating."
^^^^^^
When I enter something in the Format code
field, the Category field automatically changes to User-defined,
unless I enter a format that already is pre-defined, which it is in
this case, so in the last
example, it
is automatically switched to currency. In the number format example, I think it
automatically switched to User-defined. If I first enter something in
the Format code field and then
select something else in the Category field, the Format code field
changes immediately to what's
selected in the Category field and in the
Format field, so there is no option there really. What happens
happens, kind of.
About: *"Tools â†' Options… â†' OpenOffice.org Calc â†' View â†' Display
â†' Zero Values":*
Wow… something happened to my nice right arrows! They turned into *"â†'"*and
my "..." character turned into *"…"*. This usually happen when the
receiver, in this case [EMAIL PROTECTED], doesn't use UTF-8. Is that right,
glgxg? Is it ISO 8859-1? Or maybe WIndows 1252? Glgxg is a funny name by the
way... I thought almost everyone used UTF-8 today, sorry for the
inconvenience, but I will probably continue using it, until something new
and better shows up...
Johnny Andersson
*
**
*
