Cell in Excel

Cell in Excel

This function examines a cell and displays information about the contents, position and formatting.

Microsoft Excel Function

=CELL("TypeOfInfoRequired",CellToTest)                                                   

         

                                     

Formatting                                                                                           No special formatting is needed.

                                                                                                                      

Content Data

The cell address.	$D$3	=CELL("address",D3)
The column number.	4	=CELL("col",D3)
The row number.	3	=CELL("row",D3)
The actual contents of the cell.	0.175	=CELL("contents",D3)

Formatter

Numeric Format	Code
General	G
0	F0
#,##0	,0
0.00	F2
#,##0.00	,2
$#,##0_);($#,##0)	C0
$#,##0_);[Red]($#,##0)	C0-
$#,##0.00_);($#,##0.00)	C2
$#,##0.00_);[Red]($#,##0.00)	C2-
0%	P0
0.00%	P2
0.00E+00	S2
# ?/? or # ??/??	G
m/d/yy or m/d/yy h:mm or mm/dd/yy.	D4
d-mmm-yy or dd-mmm-yy	D1
d-mmm or dd-mmm	D2
mmm-yy	D3
mm/dd	D5
h:mm AM/PM	D7
h:mm:ss AM/PM	D6
h:mm	D9
h:mm:ss	D8