Thread: How do I add a leading 0 to a group of cells
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Fuzy Duk Fuzy Duk is offline
external usenet poster
  
Posts: 3
Default How do I add a leading 0 to a group of cells
Awsome Dave! Thanks for saving my valuable time.

"DaveO" wrote:

In cell B1 use this formula ...

="0" & A1

Copy and paste this all the way down your data and it'll do as you ask.

HTH.

"Fuzy Duk" wrote:

I have a column with 934 lines in it and need to add a leading zero to each
line. How do I do this without adding line by line?
Reply With QuoteReply With Quote