View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] leonliev@gmail.com is offline
external usenet poster
 
Posts: 5
Default sorting excel data

The visual basic code is:

Selection.Replace What:="-", Replacement:="-0", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False,
_
ReplaceFormat:=False

I can see what's going wrong, but I have no idea how I can correct
this...
Any help is welcome

Thnx,
Leon