Thread
:
add "0" to the beginning of each value
View Single Post
#
2
Bob Phillips
Posts: n/a
If it is just presentation, use a custom format of 0000.
--
HTH
Bob Phillips
"Jane" wrote in message
...
my data reads:
627
628
629,
etc.
I need to add a "0" to the front of each number. Is there an easy formula
to do this?
thanks! jane
Reply With Quote