Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Conversion - Number field to Currency

  Asked By: Sheldon    Date: Mar 24    Category: Sharepoint    Views: 2735

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...



3 Answers Found

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

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

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


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

I just created a column to test this:


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.