Can't Get Cell Format

New Contributor

I want to use the formula of "=CELL("format",I26)" in Sharepoint online Excel, but it doesn't work...

Why??

 

Kayvan560_0-1646437116969.png

 

2 Replies

@Kayvan560 

According to the official documentation CELL Function :

 

"format"

Text value corresponding to the number format of the cell. The text values for the various formats are shown in the following table. Returns "-" at the end of the text value if the cell is formatted in color for negative values. Returns "()" at the end of the text value if the cell is formatted with parentheses for positive or all values.

Note: This value is not supported in Excel for the web, Excel Mobile, and Excel Starter.

But I use it in Excel for web...