View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
shapper shapper is offline
external usenet poster
 
Posts: 22
Default Number Format. Switch Comma to Dot

Hello,

I have the following number in a cell:
12,892.70

This is recognized as text. I tried to change the cell format to
number and it does not work.
The format should be 12.892,70.

Is there a way to make this change on the Sheet instead of VB?

Thanks,
Miguel