ExcelBanter - How do you limit the number of charactors in a cell?

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

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

- - How do you limit the number of charactors in a cell? (https://www.excelbanter.com/excel-discussion-misc-queries/185947-how-do-you-limit-number-charactors-cell.html)

Miracole

How do you limit the number of charactors in a cell?

I have an Excel form that I need to limit the # of charactors in one of the
cells ( a coment) how can I do this?

santaviga

How do you limit the number of charactors in a cell?

Right click cells use format cells and custom to ######## (## how many
characters yo need.

MN

"Miracole" wrote:

I have an Excel form that I need to limit the # of charactors in one of the
cells ( a coment) how can I do this?

santaviga

How do you limit the number of charactors in a cell?

Try Data Validation

MN

"Miracole" wrote:

I have an Excel form that I need to limit the # of charactors in one of the
cells ( a coment) how can I do this?

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