ExcelBanter - how can I enforce entry to numbers only?

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - how can I enforce entry to numbers only? (https://www.excelbanter.com/excel-discussion-misc-queries/116620-how-can-i-enforce-entry-numbers-only.html)

Joseph

how can I enforce entry to numbers only?

Hi,
I want to restrict entries to numbers only in some cells that are related to
a formula, is it possible to format a cell for numbers and not alphabet ?

thanks

Gord Dibben

how can I enforce entry to numbers only?

Check out DataValidationAllow.

Gord Dibben MS Excel MVP

On Sun, 29 Oct 2006 20:31:01 -0800, Joseph
wrote:

Hi,
I want to restrict entries to numbers only in some cells that are related to
a formula, is it possible to format a cell for numbers and not alphabet ?

thanks

Joseph

how can I enforce entry to numbers only?

It works great thanks.

"Gord Dibben" wrote:

Check out DataValidationAllow.

Gord Dibben MS Excel MVP

On Sun, 29 Oct 2006 20:31:01 -0800, Joseph
wrote:

Hi,
I want to restrict entries to numbers only in some cells that are related to
a formula, is it possible to format a cell for numbers and not alphabet ?

thanks

All times are GMT +1. The time now is 11:31 PM.