View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Raul Sousa Raul Sousa is offline
external usenet poster
 
Posts: 17
Default Comma replacement

I am in Europe. I use by default coma as decimal separator.
In a particular situation I need to replace the coma by point. I have this
code:
Columns("p:p").Select
Selection.NumberFormat = "General"
Selection.Replace What:=",", Replacement:="."
But nothing is happening. Column P still has comma as decimal separator.

What am I doing wrong?