Thread: Pad with leading zeros?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
mark mark is offline
external usenet poster
  
Posts: 196
Default Pad with leading zeros?
Format(C,"000")


-----Original Message-----
Ex:
A = Y (string)
B = 1234 (string)
C = 1 (numeric)
A
B C
Final string would look like this: Y1234.001

Reply With QuoteReply With Quote