Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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: 75
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
 



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 08:36 PM.


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