Number of Significant Figures to Display

[Chet Hurd]

How can I format a column so that it will only show like 2 or 3 numbers to
the right of the decimal point?

 

[JackD]

You can not format the numbers, but you can use a formula in a text column
to format the number like this:

Format([Number1],"###.00")

You can use the Format function in a number field, but it does not perserve
the correct number of decimal points.

You could also work on the string itself:

left([Number1],instr([Number1],".")+2)

This will return the value in custom field Number1 with two digits or less
to the right of the decimal point. Change the "+2" to whatever value you
want. It won't create any digits to the right of the decimal if the original
number did not have them.

An alternative is something like this:

(([Number1]*100)\1)/100


-Jack ... For project information and macro examples visit
http://masamiki.com/project

..

 

[Chet Hurd]

JackD,

You are awesome. Thank you very much. Your first suggestion worked exactly
how I intended.

- Chet

You can not format the numbers, but you can use a formula in a text column
to format the number like this:

Format([Number1],"###.00")

You can use the Format function in a number field, but it does not perserve
the correct number of decimal points.

You could also work on the string itself:

left([Number1],instr([Number1],".")+2)

This will return the value in custom field Number1 with two digits or less
to the right of the decimal point. Change the "+2" to whatever value you
want. It won't create any digits to the right of the decimal if the original
number did not have them.

An alternative is something like this:

(([Number1]*100)\1)/100


-Jack ... For project information and macro examples visit
http://masamiki.com/project

..

How can I format a column so that it will only show like 2 or 3 numbers to
the right of the decimal point?

 

[JackD]

Glad to be of help.

--
-Jack ... For project information and macro examples visit
http://masamiki.com/project

..

JackD,

You are awesome. Thank you very much. Your first suggestion worked exactly
how I intended.

- Chet

You can not format the numbers, but you can use a formula in a text column
to format the number like this:

Format([Number1],"###.00")

You can use the Format function in a number field, but it does not perserve
the correct number of decimal points.

You could also work on the string itself:

left([Number1],instr([Number1],".")+2)

This will return the value in custom field Number1 with two digits or less
to the right of the decimal point. Change the "+2" to whatever value you
want. It won't create any digits to the right of the decimal if the original
number did not have them.

An alternative is something like this:

(([Number1]*100)\1)/100


-Jack ... For project information and macro examples visit
http://masamiki.com/project

..

How can I format a column so that it will only show like 2 or 3 numbers to
the right of the decimal point?

 

[Justin]

Wow... I have the same question. This seems like a pretty impressive work
around when Project should have a button just like Excel for "Increase
Decimal" or "Decrease Decimal". Kind of a basic functionality I'd think... I
don't want to see my 6 figure budget to the nearest cent, and it actually
makes it harder to report to the sponsor because they want their (dollar)
figures to match mine. Grrrr.

Glad to be of help.

--
-Jack ... For project information and macro examples visit
http://masamiki.com/project

..

JackD,

You are awesome. Thank you very much. Your first suggestion worked exactly
how I intended.

- Chet

You can not format the numbers, but you can use a formula in a text column
to format the number like this:

Format([Number1],"###.00")

You can use the Format function in a number field, but it does not perserve
the correct number of decimal points.

You could also work on the string itself:

left([Number1],instr([Number1],".")+2)

This will return the value in custom field Number1 with two digits or less
to the right of the decimal point. Change the "+2" to whatever value you
want. It won't create any digits to the right of the decimal if the original
number did not have them.

An alternative is something like this:

(([Number1]*100)\1)/100


-Jack ... For project information and macro examples visit
http://masamiki.com/project

..
How can I format a column so that it will only show like 2 or 3 numbers to
the right of the decimal point?

 

[Justin]

Well I found the answer to what I was looking for anyway.

Tools/Options/View/"Currency options for "*.ppt"/Decimal digits.

Wow... I have the same question. This seems like a pretty impressive work
around when Project should have a button just like Excel for "Increase
Decimal" or "Decrease Decimal". Kind of a basic functionality I'd think... I
don't want to see my 6 figure budget to the nearest cent, and it actually
makes it harder to report to the sponsor because they want their (dollar)
figures to match mine. Grrrr.

Glad to be of help.

--
-Jack ... For project information and macro examples visit
http://masamiki.com/project

..

JackD,

You are awesome. Thank you very much. Your first suggestion worked exactly
how I intended.

- Chet

:

You can not format the numbers, but you can use a formula in a text column
to format the number like this:

Format([Number1],"###.00")

You can use the Format function in a number field, but it does not perserve
the correct number of decimal points.

You could also work on the string itself:

left([Number1],instr([Number1],".")+2)

This will return the value in custom field Number1 with two digits or less
to the right of the decimal point. Change the "+2" to whatever value you
want. It won't create any digits to the right of the decimal if the original
number did not have them.

An alternative is something like this:

(([Number1]*100)\1)/100


-Jack ... For project information and macro examples visit
http://masamiki.com/project

..
How can I format a column so that it will only show like 2 or 3 numbers to
the right of the decimal point?