View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Justin1973 Justin1973 is offline
external usenet poster
 
Posts: 2
Default excel question

Thanks :)

"mudraker" wrote:


try

=LEFT(A1,3)&"."&MID(A1,4,LEN(A1)-3)


--
mudraker
------------------------------------------------------------------------
mudraker's Profile: http://www.excelforum.com/member.php...fo&userid=2473
View this thread: http://www.excelforum.com/showthread...hreadid=552082