Thread: How do you delete leading zeros from numbers?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Nick Hodge Nick Hodge is offline
external usenet poster
  
Posts: 1,173
Default How do you delete leading zeros from numbers?
Format via FormatCells...NumberCustom and enter .0;-.0;0

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"emronexcel" wrote in message
...
I want to see .5 not 0.5

Reply With QuoteReply With Quote