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

[Guest]

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!

 

[Douglas J. Steele]

Try "#.#\%"

\ is an escape character in formats.

 

[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%

Try using the \ character to quote the percent:

#.#\%


John W. Vinson[MVP]

 

[Guest]

My apologies, it did work. Perfectly.

Thanks a million!!

Kim Helstein