Formatting numbers and formulas as text doesn't really work

Hi,
I have some text that also contains numbers with a decimal point. I am trying to remove all the digits from the text using the replace function. Although the entire data range is formatted as text, I cannot remove the digit just left of the decimal point. If it's a 0, nothing happens, if it's another digit it is changed into 0.
I am using a macro, but I have the same problem when working directly with Excel's functions.
What should I do?
Thanks,
Chen