formatting help

M

mpsamuels01

Hey I was wondering can I get a little help in the custom formatting
section. I have table full of 6 digit numbers but when there are
0(zeros) involved access ignores them and screws up everything. The
problem is the zeros are not always in the same place I have numbers
like 214000 or 214020 or 214007 and the results are 214 or 21420 or
2147. How can I fix this. Those zeros are there when imported but are
still ignored.
 
R

Rick B

I have never seen a field delete zeros unless they are in the left position
which is normal for a number. 00123 and 123 are, of course, the same thing.

You say the zeros are there when imported (meaning they appear in the
table?) but are still ignored. What do you mean they are IGNORED?

Rick B
 
M

mpsamuels01

Hey guys thanks for your help but I think it might be an error on my
part from importing the data from excel. I will let you as soonas i
figure it out.
 
Top