Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Cell Formulas

under the Data drop down in excel there is a category named
"Validation" you can change the validation rules so that it only exepts
text.
Haider.

santaviga wrote:
Does anyone know if its possible to have a range of cells that you can only
enter a certain text. e.g. cell range is A1:F13, this range you can only
imput an X. If you try to enter anything else like any other other letter or
number it will not allow it.


Any ideas.


Mark


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Two formulas in on cell based on two numbers in another cell? Melody Excel Discussion (Misc queries) 5 March 19th 10 07:51 PM
Carrying formulas over to new cell when old cell is deleted: possi Karl Excel Worksheet Functions 0 June 24th 08 01:10 PM
How to trace a cell? Which cells use a special cell in formulas? SupperDuck Excel Discussion (Misc queries) 4 December 1st 06 04:17 PM
Copying formulas from cell to cell to cell to....... Tom Hardy Excel Discussion (Misc queries) 3 June 15th 06 03:29 PM
change cell value greater than another cell value using formulas Unsure? Excel Worksheet Functions 2 April 2nd 06 10:24 PM


All times are GMT +1. The time now is 09:30 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"