Microsoft Office Tutorials and References
In Depth Information
Using the CELL Function
filename
filename Returns the filename as text, including the full path of the
file that contains reference. If the worksheet that contains reference
has not yet been saved, empty text ("") is returned. Interestingly, this
argument now also returns the worksheet name if the workbook con-
tains multiple worksheets.
format
format Returns the text value corresponding to the number format
of the cell. Returns - at the end of the text value if the cell is
formatted in color for negative values. If the cell is formatted with
parentheses for positive or all values, () is returned at the end of
the text value. The values reported as a formatreflect old Lotus
1-2-3 codes. When you format, Excel attempts to convert the current
numeric format to an old-style Lotus 1-2-3 formatting code. Table
12.7 shows some examples.
Table 12.7. Custom Codes in Excel and Lotus 1-2-3
parentheses
parentheses Returns 1 if the cell is formatted with parentheses
for positive or all values; otherwise, returns 0.
color
color Returns 1 if the cell is formatted in color for negative val-
ues; otherwise, returns 0.
Search JabSto ::




Custom Search