Thread: Adding into cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Andrea Jones Andrea Jones is offline
external usenet poster
  
Posts: 63
Default Adding into cell
You can use a formula in another cell:

=CONCATENATE(LEFT(A1,2),".",MID(A1,3,3),".",RIGHT( A2,3))

Andrea Jones
www.stratatraining.co.uk
www.wrekinpublishing.com

"fazz" wrote:

i wish to change a cell that contains "27809980" to "27.809.980" it is a text
cell
Reply With QuoteReply With Quote