Thread: How to automatically add 000 at the back of my numbers?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Toppers Toppers is offline
external usenet poster
  
Posts: 4,339
Default 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?
Reply With QuoteReply With Quote