Thread: left padding + blank
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
Alex Alex is offline
external usenet poster
  
Posts: 12
Default left padding + blank
Hello,

Is it possible to left pad a cell, but only if it's not blank ?

eg,
600 = 00600
50000 = 50000
[blank] = [blank]

(I've just succeeded for non-blank cells)

Thanks in advance.
Reply With QuoteReply With Quote