View Single Post
 
Old 02-19-2020, 07:24 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
 
Join Date: May 2017
Posts: 949
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default

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".
Reply With Quote