There are many mistakes in Help, but I get C0 using your format.

You might need to force a recalc on the cell (edit it and re-enter, or change the value in A1) to get the correct result. Changing
the format would not cause a recalc.

--

John Green - Excel MVP
Sydney
Australia


"chengj" wrote in message ...
Are there some mistake in Excel'HELP(or MSDN)?
when I use the function CELL(info_type, reference)
with "info_type"="format".And I set cell--A1'cellformating
to be $#,##0_);($#,##0) according Excel'HELP(or MSDN)
CELL("format", A1) = C0(but what I got was ",0")!


Thank you !