formula like =CELL("type",A2) returns "b" for any cell format for me. But =CELL("format",A2) returns depending on format of A2:
General - "G";
Number - ",0" or ",2", etc.;
Currency - "C0" or "C2", etc.;
Date - "D1" or "G";
Percentage - "P0" or "P2", etc;
Text - "G".
|