Thank you, I had looked at Custom and thought that would overwrite the
digits. It worked great. I appreciate it.

"Elkar" wrote:

Under Cell Formatting, select Custom and enter: 0000

HTH,
Elkar


"Headfish" wrote:

I have a field with a bunch of numbers from 1 to 1000. They need to be
displayed as 0001, 0002...0999, 1000. I was looking for a function or number
formatting way of accomplishing this.