Hi!
I would like for a cell to automatically fill a string to 7 characters
no mater how many characters they enter. example: If the user enters
A256 I want the cell to display A000256 or if the user enters A0256 it
will display A000256. Is there a way for formating to do this? If not
then what would the code look like to make it happen?
Thanks for any help!!


--
Brian Matlack
------------------------------------------------------------------------
Brian Matlack's Profile: http://www.excelforum.com/member.php...fo&userid=3508
View this thread: http://www.excelforum.com/showthread...hreadid=520330

Hi!

Do all the entries start with the letter "A"?

Maybe something like this:

Custom format: "A"000000

Then the users would enter just the number, 256 (or whatever). However,
using this format the true underlying value of the cell would be numeric 256
and not the displayed value of A000256.

Another way:

Use a helper cell:

A1 = A256

B1 = formula:

=LEFT(A1)&TEXT(MID(A1,2,255),"000000")

Biff

"Brian Matlack"
wrote in message
news:Brian.Matlack.24dgfc_1141856405.7611@excelfor um-nospam.com...

Hi!
I would like for a cell to automatically fill a string to 7 characters
no mater how many characters they enter. example: If the user enters
A256 I want the cell to display A000256 or if the user enters A0256 it
will display A000256. Is there a way for formating to do this? If not
then what would the code look like to make it happen?
Thanks for any help!!


--
Brian Matlack
------------------------------------------------------------------------
Brian Matlack's Profile:
http://www.excelforum.com/member.php...fo&userid=3508
View this thread: http://www.excelforum.com/showthread...hreadid=520330