find and replace

[scambug]

Hi I have a find and replace code here that replace .[dot] to 0.[zero and dot]
but my promblem is when i run to the entire column all dots replace to zero and dot
how can i change this
i need only that starts .[dot] in a column replaces 0. [zero,dot]

Columns("A:A").Select
Selection.Replace What:=".", Replacement:="0.", LookAt:=xlPart, _
SearchOrder:=xlByColumns, MatchCase:=False

thanks

 

[Stu Dapples]

Set a filter to the data, custom filter, begins with, enter the .

You should now be able to see the cells beginning with . and do your find replace on the selected cells....

I think!

 

[scambug]

Thanks, Great help