floatval() numbers mac

[ronnievanderstegen]

Hi

 

In the program Numbers on mac I have a column with prices but they are displayed in different shapes, like this:

 

1.000,00

1.000.00

1000.00

1000,00

1000

 

I found this code to use the function floatval()

 

<?php 

function floatvalue($value) { 
     return floatval(preg_replace('#^([-]*[0-9\.,\' ]+?)((\.|,){1}([0-9-]{1,2}))*$#e', "str_replace(array('.', ',', \"'\", ' '), '', '\\1') . '.\\4'",$value)); 
} 
?>

 

Can anyone tell me if I can use this function to make all numbers look like 1000.00? If so how to do this?

Is it possible to use the function on a column in Numbers (for Mac)? If so, how to do this?

 

Thanks already for the help.