Is there any way to make the format (General, Number, Text) of the cells visible?

[AA Arens]

Is there any way to make the format (General, Number, Text) of the
cells visible?

I always have to rightclick > Format to check it.

Bart
Ex2003

 

[RichardSchollar]

Hi Bart

There's a way to create a formula to display the number format using
an XLM4 macro function:

1. Go Insert>Name>Define and name the formula you are about to create
something like NumFmt (you have to do it this 'indirect' way when
using XLM4 macros) and in the refers to box type:

=GET.CELL(7,OFFSET(INDIRECT("RC",FALSE),0,-1))

and click OK.
2. Now this formula can be used in any worksheets in this workbook and
will display the number format of the cell to its immediate left (ie
if entered in B1 then it will give the number format of A1). Enter
like so:

=NumFmt

Hope this helps!

Richard