text formating

[ids_73]

hi there,

i have a column with text values of the format ccccccccc and i want as soon as i change cell to get them in the following format of cc.cc.cc.ccc

if it was just number it will be easy to do so with formating but with with text formatting is not working

any ideas?

a solution is to write vba code but i want to use that option at the end.

thank you in advance.

[dosydos]

I am not sure about a number format without vba.
You could add a blank column and use this formula.
=LEFT(A1,2)&"."&MID(A1,3,2)&"."&MID(A1,5,2)&"."&RIGHT(A1,3)

[CK76]

You can't change text format on data entry cell. You'll need another column to display it in the format desired using text manipulation (Replace() etc)
That'd be only option outside of VBA as far as I'm aware.