percent label

M

mike

How do I format a table so numbers typed in a cell display with the percent
symbol
 
G

Greg Maxey

Mike,

You could use a protected form and format your text fields as a percentage.
If you want to stick with a simple table and don't mind waiting until you
are finished with your data entry to format the cells, you could select the
cells and then do a find and replace.

Edit>Replace.
Click More>Use Wildcards
Type ([0-9])> in the find what field
Type \1% in the replace with field

If you had entries such as 45.5
you will see 45%.5%
Just do another find and replace with
%. in the find field
and . in the replace field

Understand this is cumbersome. Another option is to use a Excel spread
sheet inserted in your table.

--
Greg Maxey
A peer in "peer to peer" support
Rockledge, FL
E-mail for additional help, within reason, if you like. I may not
always solve your problem, but no charge if I do. To e-mail, first edit
out the "w...spam" in the displayed address.
 

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

Top