Leading the way in Microsoft Office Development

Using the CELL() function

This function should help you to determine whether a cell has been formatted as Text or if an apostrophe has been added to the start of the value.

A1 - contains a cell formatted as Text

A2 - contains a prefix

Cell("format",A1) = G - this means it has the general number format ??

Cell("prefix",A2) = ' - meaning the number has been prefixed - although this returns Nothing when the cell is formatted as Text

Cell("prefix",A1) = Nothing

Cell("type") = ?? - returns "v" when the cell contains more that 255 characters

Using the TYPE() function

Things to Remember