View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
patrick molloy patrick molloy is offline
external usenet poster
 
Posts: 391
Default #Holding values in different format#

did you try just formatting the cell?
like "### ### ###" for example

if its a text string that you need rather than leaving
the data as a number, then you could use someting like
txt = textbox1.text
MyText = left(txt,4) & " " & mid(txt,5,4) & " "
MyText =MyText & mid(txt,9,4) & " " & right(txt,4)


Patrick Molloy
Microsoft Excel MVP

-----Original Message-----
Hi,

A 16 digit number is to be entered into a vbform

textbox,
on leaving or pressing enter, I would like this number:

e.g abcdefghijklmnop

to be displyed in this format:

abcd efgh ijkl mnop

Can anyone help?

Thanks

Dean
.