Turning Data in to a 1

[ads_1471]

Hi All

On m work book I have shifts in put in to cels. Such as 13:00 - 21:00 in one cel. However on another worksheet I want that to show as a 1.

So basically when ever numbers are typed in on a sheet I want a 1 to show, However if a word is typed I want a blank cel

Can anyone advise?

 

[offthelip]

An equation like this will do it for you:

=IF(ISNUMBER(A1),1,"")