Thread: How can I concatenate text with leading zeros
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Beege Beege is offline
external usenet poster
  
Posts: 66
Default How can I concatenate text with leading zeros
Dick wrote:
When I concatenate a number with leading zeros, the zeros are removed. How
can I retain them?

Dick,

Try & TEXT(A1,"00000") when concatenating?

Beege
Reply With QuoteReply With Quote