No it doesn't. A format of 0000 will still display numbers greater than 4
digits properly. What steps are you following where you get only 4 digits?
What version of Excel do you have?

Regards,
Fred.

"EngelseBoer" wrote in message
...
how will this affect a number 12345 0r 123456
i tried formating the coloumn as 0000
and that forces 5 and 6 digets to 4 -- not good
and if i make it 000000
then i get 000080
not what i want

maybe i hope for too much ?

"Gord Dibben" wrote:

=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