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.
|