Thread: Replace leading zeros with leading spaces ?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rick Rothstein Rick Rothstein is offline
external usenet poster
  
Posts: 5,934
Default Replace leading zeros with leading spaces ?
Use this...

Format(12, "@@@")

--
Rick (MVP - Excel)


"Gary" wrote in message
...
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