Michael,

Click on the cell that you want to include the zero's in the word. Right
click and go down to format cells. Go to the "number" tab and there will be
a box on the left side. Select Text then click "OK". You should be able to
type zero's in front of your text from that point.

Jeff

"Michael" wrote:


Need some Help.

Trying to include leading zeros into my inputs.

eg "1234" to display "0001234" and "Sample product" to display
"00Sample0product"

I was able to do this for the numbers but was not able to display
preceeding 00 and inserting 0 for blank space

Further more when I combine the different cells via "CONCATENATE" function I
found the preceeding zeros disappearing.

Can someone please help?

Thanks


Michael