How to automatically add 000 at the back of my numbers?

How to automatically add 000 at the back of my numbers?

If they are NUMBERS (not TEXT) multiply them by 1000. If they are TEXT
concatenate the cells with "000" i.e. =A1 & "000" OR =VALUE(A1)*1000; the
latter will convert the text to number format.

HTH

"devillsad" wrote:

> How to automatically add 000 at the back of my numbers?