How to automatically add 000 at the back of my numbers?
T Toppers Aug 15, 2006 #2 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
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
