function CELL( )

  • Thread starter Thread starter chengj
  • Start date Start date
C

chengj

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 !
 
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.
 
Back
Top