Select column A
Format as General (anything but Text).
Edit|Replace
what: . (decimal point)
with: .
replace all

Excel should see the value as a number and will display 3.000 as 3 (in General
format).



Aline wrote:

There's a column with results (1.000, 2.000, or 3.000, the Format Cells... is
Text) I would like to replace with 1, 2 or 3.

Is there a easier way to do it? I have tried =REPLACEB(A1, 2,4," "), but
it's not working. In the end I had to use Find function : find 3.000 and
replace 3; find 2.000 and replace 2, find 1.000 and replace 1.
(I've also tried change Format Cells from Text to General, and Number...)

A B
Level Obtained Level
3.000 3
2.000 2
2.000 2
3.000 3
1.000 1

Thanks,
Aline
--
Aline

--

Dave Peterson