ExcelBanter - Defaulting a cell to 0

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Defaulting a cell to 0 (https://www.excelbanter.com/excel-programming/301495-defaulting-cell-0-a.html)

Erin

Defaulting a cell to 0

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?

Jan Karel Pieterse

Defaulting a cell to 0

Hi Erin,

I want to force the user to enter a numeric value here.

Check out Data, Validation.

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com

All times are GMT +1. The time now is 10:06 PM.