SOLVED

Changing amount to MIllion

Copper Contributor

Is there any way to cenvert an amount to Million in the cost field? I am unable to do the same. I am working on MS Project ver 2016.

6 Replies

Prosenjit0802,
What exactly do you mean, "convert an amount to million"? Project is designed to handle 999,999,999,999.99 in any cost field. An example with a screen shot would help us help you.
John

@John-projectThanks for Responding.... My question is suppose i have a cost field where the amount is showing as "₹ 12,919,957,000.00". Now i want this amount to be shown as 12919.96 Million... I can do this Excel.... But how do i do this in MS Projects 2016?

 

Regards

Prosenjit 

best response confirmed by Dale Howard (MVP)
Solution
Prosenjit0802,
You can also do it in Project but you'll have to use a Text field (e.g. Text1), but it can't be shown that way in any Cost field.
John
Thanks for your response
Prosenjit0802,
You're welcome and thanks for the feedback.
John
Hi Jan.

You can try to put Million in the options (File/ Options/ Display/ Currency Symbol = Million), but you would have to enter or paste the values.
1 best response

Accepted Solutions
best response confirmed by Dale Howard (MVP)
Solution
Prosenjit0802,
You can also do it in Project but you'll have to use a Text field (e.g. Text1), but it can't be shown that way in any Cost field.
John

View solution in original post