| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format cells to only accept numbers
How can we format and protect cells to not accept text, only numbers?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Format cells to only accept numbers
Hi cradino
Example for cell A1 You can try DataValidation ..Custom with this formula =ISNUMBER(A1) -- Regards Ron de Bruin http://www.rondebruin.nl "cradino" wrote in message ... How can we format and protect cells to not accept text, only numbers? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Format cells to only accept numbers
data validation - numbers
"cradino" skrev: How can we format and protect cells to not accept text, only numbers? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Format cells to only accept numbers
cradino, Use data validation. Select the cells you want to apply the data validation to. Go to DataValidation. Select Decimal or Whole number from the Allow list then choose your minimum and maximum number and click OK. HTH Steve -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=563788 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Format cells to only accept numbers
Hi, You could use Data Validation. Go to Data Data Validation then select custom and insert this formula =ISNUMBER(E10:J19).....Change range as required. You can also put instructions to the user in Input message and error messages when they try to enter non numbers This link should help http://www.contextures.com/xlDataVal01.html VBA Noob -- VBA Noob ------------------------------------------------------------------------ VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833 View this thread: http://www.excelforum.com/showthread...hreadid=563790 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
| How do I sum numbers in rolling format? (4 qtrs=4 cells to left) | Excel Discussion (Misc queries) | |||
| checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
| cell format in Excel 2002 SP3 will not accept long numbers | Excel Worksheet Functions | |||
| Cells formated as numbers are calculating like text | Excel Discussion (Misc queries) | |||
Linear Mode
