Go 4 Sharepoint

Search:

Welcome: Guest!

Sharepoint Forum

Home » Forum » Sharepoint

Ask a question

RSS Feeds

Conversion - Number field to Currency

Asked By: Sheldon Marquez Date: Mar 24, 2010 Category: Sharepoint Views: 529

my number field is a Estimated Value ($M) - (example- 1.098908 has
been entered into the number field. How can I get a $value from this
field. I have created a calculated field and with no luck...

Tagged:conversion number field to currency

3 Answers Found

Answer #1 Answered By: Alan West Answered On: Mar 24, 2010

So it's a fractional number reported in millions? That would seem to be a
simple "multiply by one million" operation; what am I missing?

Answer #2 Answered By: Maribel Todd Answered On: Mar 24, 2010

You are not missing anything - I am however not sure how to do this
ini the calculated field

=[fieldNum]*6

then change the data type from number to currency? I have tried
several ways with no luck.

Answer #3 Answered By: Akshara Negalur Answered On: Mar 24, 2010

I just created a column to test this:

=[fieldName]*1000000

Create a field, choose type "Calculated (calculation based on other
columns), add the formula, and tell it to display as Currency.

Didn't find what you were looking for? Find more on Conversion - Number field to Currency Or get search suggestion and latest updates.

Your Answer

Answer should be atleast 30 Characters.
Please put code inside [Code] your code [/Code].

Please login to post comment

Previous: Way to see all people who have modified a document in the shared documents

Next: Lost sharepoint central administration server -- recovery options?

Go4Sharepoint, is a Microsoft Featured Community. Microsoft, Windows, Sharepoint, Sharepoint logo, Windows logo, etc are trademarks of the Microsoft Corporation. All product names, logos, copyrights, and trademarks mentioned are acknowledged as the registered intellectual property of their respective owners. This site is not in any way affiliated with, nor has it been authorized, sponsored, or otherwise approved by, Microsoft Corporation.