This is exactly what I needed. Thanks very much!

I knew about Left/Right functions, but not the MID!

C

Two ways...

You could leave it as is but use a custom format. Right click on the
cell, choose Format Cells, pick Custom from the list and enter
###"."###"."#"."# in the Type box.

Or use a formula in another cell such as

=LEFT(A1,3)&"."&MID(A1,4,3)&"."&MID(A1,7,1)&"."&RI GHT(A1,1)

- John


--
CDiddy
------------------------------------------------------------------------
CDiddy's Profile: http://www.excelforum.com/member.php...o&userid=29492
View this thread: http://www.excelforum.com/showthread...hreadid=491925