I write my friend Norma Santa Fe by a problem with a spreadsheet. It imported a
database with numbers but when you open the file format changed, the number 55467 appears to him as 554.67 and so on, corridos two decimal places, and there is no way to change the format.

The easiest way to solve it is to remove that pesky comma way to recover the real values \u200b\u200band then give numerical format with two decimal places.
To remove the comma, you must pass a TEXT format. Then paint the numbers and select FORMAT - TEXT.

Then we get the point very easily. Let
SEARCH-REPLACE and say that each point of replacing a white space.

Then with REPLACE ALL, is the return to whole numbers.

And Format-Number-Two decimal we get the final result.

IMPORTANT: It is common to import data from other programs appear symbols or characters not allowed, as in this case the coma. The easiest way to eliminate them is as quoted in the example, replace the symbol in question by "nothing", which is the same as delete, except that all at once.