Good afternoon and happy Friday, all! 

We recently changed a field from a number type to a text type and it added ".00000000" to the end of every number that was previously in the field.

Example of what I mean (also see photo)
Field was "Number" type & displayed: 21095
Field changed to "Text" type & now displays: 21095.00000000

When I change it back to Number and change the decimals to none and no comma, it goes back to 21095 - but every time it is changed to Text it adds the .00000000.

Any idea on how to make this not happen, or a way to do a mass update to remove the .00000000 at the end on a query?

Of course - this field doesn't have the same entry in all of the records, it's unique, so I can't do a general mass update to replace what is in the field.

I tried Googling and searching all the manuals.. but having a lot of trouble.

tyia! 

Okkkk well NEVERMIND! What I put in the last thread worked. I'll leave it here for others to use if they need to!