View Single Post
  #1   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 have the following problems:

I have a "number" written as 1,000.00 - however I need to convert it
in 1.000,00 (whereby ful stop is a thousands seperator and a comma is
a decimal seperator )

the second number is written as 1,000M whereby M means 1000 therefore
the number should be equal to 1.000.000

how could i convert the numbers in useful formats?

thanks for your help