Turning Data in to a 1

A

ads_1471

Board Regular
Joined
Apr 19, 2016
Messages
58
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?
 

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.
Sort by date Sort by votes
An equation like this will do it for you:
Code: 
=IF(ISNUMBER(A1),1,"")
 
Last edited:
Upvote 0
You must log in or register to reply here.

Similar threads

D
  • Question Question
VBA to Remove Text Characters From Strings
Replies
5
Views
892
Fuji
F
I
  • Solved
Show text in worksheet cell advising user to enter the relevant text here
2 3
Replies
23
Views
665
Snakehips
Snakehips
U
  • Question Question
Information overwriting when transferring
Replies
7
Views
488
UTB
U
D
  • Solved
Summing the results of multiple cells based on other data
Replies
3
Views
106
Fluff
Fluff
J
  • Solved
Combined formula
Replies
5
Views
144
Peter_SSs
Peter_SSs

Forum statistics

Threads
1,224,823
Messages
6,181,175
Members
453,021
Latest member
Justyna P

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top