Do you still want them to be text?

If not

=--(A1)/100

if text

=TEXT(--(A2)/100,"@")


Regards,

Peo Sjoblom



"Bill M." wrote:

I have a column of numbers which were imported as text and need to have the
last two places changed to decimals. How do I do that?