Use Format | Cell and use the Custom tab, enter 100###### as a new custom
format to be applied.

"gti_jobert" wrote:


Hi all,

I have a textbox where I want the user to enter a 6 digit
number.....how can I format the text box so it always displays
'100xxxxxx' where x = the 6 digit user input.

TIA guys!


--
gti_jobert
------------------------------------------------------------------------
gti_jobert's Profile: http://www.excelforum.com/member.php...o&userid=30634
View this thread: http://www.excelforum.com/showthread...hreadid=541029