Custom number format with text

hi
you can restrict length of text if you go to data validation
in settings, you select option text length, then equla to
number of characters you want in a cell.
by this way, you can't enter more or less characters specified.
hopefull that's what you are looking for

A modification to the above formula

Please Login or Register  to view this content.

Copy + Past special to copy

Regards

I tried the suggestion in the B1 cell, and also the suggestion in the F8 cell. I copied the formula into the custom validation window, but both formulas bring up a dialog box that says this will result in an error.
I am not sure what I am doing wrong.
Thank you for the suggestions.

Originally Posted by karstens

Is there a way to have a format on a cell that would allow for:

3 Characters - 6 numbers?

I don't quite understand what you need.
Do you want to enter a continuous string in a cell so that it formats as needed on exit?
Should that be in the same cell or is another one OK?

I am trying to create an input form where managers have to enter their project detail. It is important that they always enter the same format. Our projects are three letters that represent the company, a dash, and a 6 digit assigned project code. So one may be NEW-001266. Another company may be PEO-012279.

I wanted to format the cell, so it required them to always follow the correct format. I could use custom number formatting by using "NEW-"####. but that only works for the "NEW" company and all companies will use the same form.

Originally Posted by Marcol

Try this
Data Validation > Custom
Formula:=

Please Login or Register  to view this content.

Hope this helps

Thank you for the suggestion. When I use this, it still allows me to put other data in there that is not formated. So I could just type NEW in there and it would not error off, which is what I would have thought data validation should do in this case.

If users are not forced to enter all three letters, AND all 6 numbers, we will always be sending the form back to them to enter it correctly.

Maybe I was doing something wrong that it allows incorrect formats to be entered.
Thanks again for your help.

My mistake posted wrong attachment give me 5-10 mins

Try Post #8 again, it should work better now.

Sorry about that

Sorry so sound dumb, but when I go reopen #8 it does the same thing. Not sure what I need to do.

I go back up to post #8
Click on karstens_Book1.xls
It opens in excel, shows A2:A19 with the data validation in it, but it is the exact same as the first time when you said it wasn't working.
I can click in any of those cells and type incorrect data.
I tried to restart my computer, thinking it was still opening your first version of the excel document. It is like I am not getting the updated version.

Try Post #13

AH! There it is! AND it works! Sorry about that! Thank you very much for your help!