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

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How to automatically add 000 at the back of my numbers? (https://www.excelbanter.com/excel-discussion-misc-queries/104971-how-automatically-add-000-back-my-numbers.html)

devillsad

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

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

Toppers

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?

All times are GMT +1. The time now is 12:31 AM.