Thread: Replace leading zeros with leading spaces ?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gary Gary is offline
external usenet poster
  
Posts: 273
Default Replace leading zeros with leading spaces ?
I am using Excel 2007.
Format (12,000) gives me 012
I want (12,??0) to be 12 with a leading space

Question mark doesnt seem to work in Excel 2007

Reply With QuoteReply With Quote