Can you help with Excell?

change the cell property to text rather than number

format > cells > number > text

Change the format of the cell to Text.

Right click on the cell or range of cells. Go to Format Cells. Change the category of the cell(s) to Text or Special / Zip Code.

Follow these steps and it should work:

Right click on the top of the column

Click Format Cells

In the number tab click on the Category: Special

Choose the format you are looking for: Zip, Zip +4 or Social Security Number

Press Okay.

That should work. If not let me know.

Change the format of the cells to a general format instead of a number format(all cells in a excel worksheet are automatically set to this by default for some reason)

Regards

Rob

this is easy, the cell is formatted for numbers and automatically deletes the extra zeros. If you go to Format, Cells, and change the formatting to TEXT it will accept anything you put in. Disregard the red triangle that will appear in the top left corner, it is alerting you to a possible mistake.

They have a zip code format, (Format-Cells) but if you are attempting to use Mail Merge to do your labels in Word, the problem will rear its ugly little head again.

You can either change the formatting to Text, or you can enter a ' in front of the zero ( '00008) after you hit enter the ' will dissappear. But don't do both or it will print the '

right click on the cell then click format cells. Format it to text, then retype the zip and it won't delete your 0

Highlight the cell or cells.

Format > cell from the menu.

Change to text entry.

right click on the cell that the number is in and change the number option... you are able to choose like with a dollar symbol, or time, and other things like that... hope this helps

Modify the format of that cell.