tab delimiting numbers

E

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
 
E

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 ?
 
F

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.
 
Top