View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
zyus zyus is offline
external usenet poster
 
Posts: 4
Default Leading Zero as value not appearance

When i use formatting cell custom with 0000 i manage to add leading zero but
the problem is the leading zero only as appearance. Is it possible to make it
as value in the cell