Defaulting a cell to 0

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a cell formatted as numeric. There are other calculations based on this cell. If the user puts a space or a character in the cell, I get #Value in my calculation cells. I want to force the user to enter a numeric value here. Anyone have code to do this?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I want to make One Cell mandatory if another cell has a specific value , can anyone help me? 0
conditional format fails when copied 1
single cell time entry as time - time; Ever seen this? 12
custom function - finding cell address 4
Sumproduct & VBA 4
passing a non numeric cell for numeric comparison 2
VBA set thick borders around non empty cells in range 0
Multiple Fxns in single sheet module 0

Back
Top