View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Luke M Luke M is offline
external usenet poster
 
Posts: 2,722
Default add 0 i astored many of numbers

Format the cells, got to custom format.

Use:
0######

Just make sure you use enough #'s to cover the longest number.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"mohamed gomaa" wrote:

i need to add 0 in the beginig of each noumer in a colum