Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-13-2022, 10:26 AM
hedg hedg is offline Decimal places of custom text field Windows 10 Decimal places of custom text field Office 2019
Novice
Decimal places of custom text field
 
Join Date: Jun 2022
Posts: 2
hedg is on a distinguished road
Default Decimal places of custom text field

Hi,



I am new to MS project, I am preparing the project report with the planned percentage of completion. Since this column has the formula to convert number into percentage, it is giving long digit number. I want to know how to bring the number of decimal places to 0 or 0.0%. please find attached screen shot.

Thank you in advance for helping.
Attached Images
File Type: png Controlling decimal place.png (83.5 KB, 10 views)
Reply With Quote
  #2  
Old 06-16-2022, 12:46 PM
ProjectPlanner's Avatar
ProjectPlanner ProjectPlanner is offline Decimal places of custom text field Windows 10 Decimal places of custom text field Office 2019
Advanced Beginner
 
Join Date: Mar 2021
Location: UK
Posts: 72
ProjectPlanner is on a distinguished road
Default

Assuming the current formula in Planned % Complete i.e. (Text4) custom field is = x + y, insert this formula into the format function, so that it becomes,

= Format ((x+y), "0.0%")

The changes to your formula are highlighted in bold.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Decimal places of custom text field Decimal Places DanMichSr Outlook 2 12-21-2018 05:26 PM
How to align decimal places in regular order? Revathi Word 3 03-22-2018 07:13 AM
Custom form - tab to **after** existing text in field luketemp Outlook 0 03-04-2016 09:11 AM
Forced extra decimal places Metamag Excel 11 08-18-2012 03:10 AM
Decimal places of custom text field Mail Merge, Number to 2 Decimal Places Vampy99 Mail Merge 7 09-25-2011 05:41 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:28 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft