Forum Discussion

Kayvan560

Copper Contributor

Mar 04, 2022

Can't Get Cell Format

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

excel

Excel for web

HansVogelaar

MVP

Mar 05, 2022

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.

Kayvan560

Copper Contributor

Mar 06, 2022

But I use it in Excel for web...