Use ctl H put a . on top and nothing on bottom.
--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"Lonnie" wrote:

I have a column(E) of numbers in this format (9018.90.8000)....I want to be
able to write a formula or format that will get rid of the periods.