View Single Post
  #3   Report Post  
Gary''s Student
 
Posts: n/a
Default How do I insert a leading zero?

Select the cells and then pull-down:

Format Cells Number Custom and enter "0"General
--
Gary's Student


"Phil" wrote:

Hello,


I have some text values (in Col C) that need 1 (one) leading zero put in:

I have some text values below:

306445854
250641222

which I want to look like:

0306445854
0250641222

How do I do this?

TIA for your replies.

Phil.