B
Barry Walker
I would like zero values at the start of a number eg.
0015624
that drops into a cell using a formula.
I know that if I type '0015624 then the first two zeros will be displayed.
if i type 0015624 into a cell it will read 15624.
i would like to display zeros without having to type ' at the beginning so
that the formula reads true.
is this possible can some one help please
Thanks
basil
0015624
that drops into a cell using a formula.
I know that if I type '0015624 then the first two zeros will be displayed.
if i type 0015624 into a cell it will read 15624.
i would like to display zeros without having to type ' at the beginning so
that the formula reads true.
is this possible can some one help please
Thanks
basil