Thanks, the 00000##### works just like I need it to.

"Naveen" wrote:

- Select the cells you want
- Click on "Format" menu
- Click "Cells"
- Click on "Number" tab
- Select "Custom" from "Category" list-box
- Type "000000" in "Type:" textbox
- Press "OK" Button

*** Please do rate ***




"ATanker62" wrote:

Hello

I have a long colum of data in the following format xxxxx, I require the
data to have five zeros before the number.

Example 12345 must be changed to display as 0000012345