=TEXT(80,"0000")

=TEXT(A1,"0000")


Gord Dibben MS Excel MVP


On Sun, 7 Sep 2008 07:01:01 -0700, EngelseBoer
wrote:

is there a way to force a number to maintian it's 0's when tab-delimiting

eg 0080 i would like it to be returned as is when delimiting
and not change to 80