View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mortir Mortir is offline
external usenet poster
 
Posts: 34
Default Changing to a usable format - number

i use ful stop as a thousands seperator and a comma as
a decimal seperator. Thet means that the number for example:
1,542.22is realy not a number because it is written in a different
format. So I cannot operate with it. Therefore I would like to know if
I can change it in a normal format, that is 1.542,22