Jump to content

Adding % sign after a number.


This topic is 7355 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

I ask this a couple of day ago, but my post is gone. Strange.

Anyway, I have a table and I would like it to show the number with a percentage sign. Instead of .23, I would like to see 23%. How can I do this.

I know with a form I can just put the % sign over the box with a clear background. But with a table it seem to be different. Any ideas?

Can I set % somewhere in the define field portion?

I am sure this is an easy, but I can't currently figure it out. Sorry for by so basic.

Link to comment
Share on other sites

Hi there,

Firstly make sure the field is set to a number field.

Then in layout mode, click onto the field and go to Format->Number

Click onto format as decimal, click on use notation and change the dropdown menu to Percent

Hope this helps

Ed.

Link to comment
Share on other sites

Just to add to that... 10% is 0.1, not 10 -- a trap that many newbies fall into.

A number field formatted as percentage will display "10" as 1000%.

Platform: / Version:

FileMaker Version:

Link to comment
Share on other sites

This topic is 7355 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.