Thread: I need to drop some leading zeros
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Cheri Cheri is offline
external usenet poster
  
Posts: 53
Default I need to drop some leading zeros
I have a spreadsheet with ID numbers. We only use 6 numbers but the IDs send
to me contain 3 zeros in front I don't need (000051585) How can I format the
numbers to drop off those first 3 zeros?
Reply With QuoteReply With Quote