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
Peo Sjoblom wrote:
=IF(A1="";"";TEXT(A1;"00###"))

Ah yes, thanks... so simple, sorry.
Reply With QuoteReply With Quote