How do I insert a "%" in the format without it actually convertin.

B

babysweet

I want to be able to enter a number (say 5.7) and have access put a "%"
beside it. However, when I enter this format as the following:

#.#"%"

It refuses to accept the "%" as text and converts the format to:

#.#%

and then my data ends up being:

5.7

instead of

5.7%

Is there any way of fixing this without a)converting the field to text or b)
using an input mask which is much to structured and makes for time-consuming
inputs (we're talking thousands of entries, and about 50 fields for each.
Any time wasted is going to add huge $$ to the project).

Thanks!
 
J

John Vinson

I want to be able to enter a number (say 5.7) and have access put a "%"
beside it. However, when I enter this format as the following:

#.#"%"

It refuses to accept the "%" as text and converts the format to:

#.#%

and then my data ends up being:

5.7

instead of

5.7%
Click to expand...

Try using the \ character to quote the percent:

#.#\%


John W. Vinson[MVP]
 
Top