Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Limit number of character per cell to 26 in excel

I need to only type 26 characters per cell and need the spreadsheet not to
accept more dat for the cell
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 179
Default Limit number of character per cell to 26 in excel

Hi Liesel

try following:

Data - Validation - Text length
or search for Validation in the Excel Help
hth

Carlo

"Liesel" wrote:

I need to only type 26 characters per cell and need the spreadsheet not to
accept more dat for the cell

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
Significant number rounding based on key cell Slashman Excel Worksheet Functions 2 August 27th 06 11:04 PM
Character limit in cell Jan Excel Discussion (Misc queries) 3 April 21st 06 02:40 AM
Instead of a negative number, I'd like to show zero... Dr. Darrell Excel Worksheet Functions 6 December 7th 05 08:21 PM
Change colour of Text if number in cell exceed limit Lewis Koh Excel Worksheet Functions 2 August 2nd 05 02:16 AM
Cell 255 character limit and formula EaglesNest Excel Worksheet Functions 6 February 27th 05 12:06 AM


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

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

About Us

"It's about Microsoft Excel"