Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #6  
Old 02-09-2024, 07:26 AM
Office_Sci Office_Sci is offline Change AutoSum Result to Zero Decimal Places Windows 11 Change AutoSum Result to Zero Decimal Places Office 2021
Novice
 
Join Date: Feb 2024
Location: UK
Posts: 5
Office_Sci is on a distinguished road
Default

Sure, Just put a £ or whatever currency symbol in front. You can also do other tweaks to this if you wanted to. For example "Total £0" will always have Total in the cell etc.

edit: by this I mean in the format box you can just put $0 and it will always have the $ before the number with no decimals

Last edited by Office_Sci; 02-09-2024 at 10:46 AM.
Reply With Quote
 

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Decimal places of custom text field hedg Project 1 06-16-2022 12:46 PM
Change AutoSum Result to Zero Decimal Places 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
Forced extra decimal places Metamag Excel 11 08-18-2012 03:10 AM
Change AutoSum Result to Zero Decimal Places 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 04:33 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