2 options.

You want value of 0123 in A1

Precede 0123 with an apostrophe.

OR in an adjacent cell =TEXT(A1,"0000")


Gord Dibben MS Excel MVP

On Tue, 1 Jun 2010 01:28:05 -0700, zyus
wrote:

When i use formatting cell custom with 0000 i manage to add leading zero but
the problem is the leading zero only as appearance. Is it possible to make it
as value in the cell