View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Minitman Minitman is offline
external usenet poster
 
Posts: 293
Default How To Detect A Negative Number In A Cell

Hey David,

Thanks for the reply.

That was the problem.

Thank you very much.

-Minitman



On Thu, 13 Mar 2008 15:11:17 -0000, "David Biddulph" <groups [at]
biddulph.org.uk wrote:

It sounds as if you've got text, rather than numbers, in your column M.
To convert to numbers, try copying a blank cell, then select column M and
use Edit/ Paste Special/ Add.