View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default a code to trace pure numbers formatted as Text

I'm not sure what pure numbers are, but this may work in most cases.

But it does assume that you're not using format|Conditional formatting for
anything else.

Select your range (I used A1:x99).
With the activecell A1, use
Format|Conditional formatting
formula is: =AND(ISNUMBER(-A1),ISTEXT(A1))
and give it a nice shade.

Be aware that these will look like they can be numbers to excel:
'1E3
'January 1, 2007
'00:12:30

1E3 = 1*10^3 = 1000
and dates and times are numbers to excel.

swordsman wrote:

Dear All,

in a world full of bugs...
and in worksheets programmed to function as required...

Can someone please avail a code/macro that can highlight a cell<s which
contains pure numbers yet are formatted as "Text".

I need to assure that even when there comes a bug to change the cell from
any formatted number into a text, i can still review easily and verify the
worksheet to assure integrity on my logical-numeric based- formulas.

TIA


--

Dave Peterson