tab delimiting numbers

[EngelseBoer]

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

 

[Gord Dibben]

=TEXT(80,"0000")

=TEXT(A1,"0000")


Gord Dibben MS Excel MVP

 

[EngelseBoer]

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 ?

 

[Fred Smith]

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.