Trouble entering percentages in my table

J

Jenn

I have a field set up with number datatype and percent format. I am trying
to enter 30% and it comes up 0%. When I put in .30 I get 0% when I put in
300 I get 300%. I can't get this field to show 30%. I need it to be a
number because I want to multiply it by another number in a query. Please
help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

REINSTALLING MS OFFICE PRO PLUS 2019 0
How can the font and size of (all) citation numbers be altered? 1
Paragraph numbering in Word 1
Amending meeting cancels all future meetings 0
Append Crosstab Query to Existing Table 0
Found few bugs in my daily routine of work in excel for MAC 0
Excel does not accept text format! 0
Found few bugs in my daily routine of work in excel for MAC 0

Top