access & excel issue
 

i made a pivot off an access data base but the figures came up showing
zero "0", and i founf out that the reason this is so is because the
excel pivot is reading the figures as text and not number and i
checked the design view everythin is in order. was wondering how i can
rectify this.