Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 01-16-2025, 08:52 AM
wcstarks wcstarks is offline Default Currency format overidden when inserting a new row Windows 10 Default Currency format overidden when inserting a new row Office 2019
Novice
Default Currency format overidden when inserting a new row
 
Join Date: Feb 2019
Posts: 5
wcstarks is on a distinguished road
Default Default Currency format overidden when inserting a new row

I maintain a spreadsheet table ordered by date from newest to oldest. I use a hidden formatting row (3) below the header to support inserting new rows at the top. There are a number of currency rows formatted as Currency. Lately, when I insert a new row at the top or anywhere below there, two columns (F and G) in the new row default to the Accounting format, forcing me to manually fix those two cells. This formatting causes the cell to override the default format an display the data centered horizontally and the $ sign is spaced further left of the currency value. Earlier, the file cache has been emptied and Office 365 has been reset. Neither procedure fixed the issue. What is causing this and how do I fix it? See attachment.
Attached Files
File Type: xlsx EdJonesInvestment-25 - Copy.xlsx (20.5 KB, 4 views)
Reply With Quote
 

Tags
formatting



Similar Threads
Thread Thread Starter Forum Replies Last Post
Default Currency format overidden when inserting a new row Change Word Table format to Currency Melsy Word VBA 3 12-04-2024 07:39 PM
SUM Two Cells Above & Format to Currency Karen615 Word Tables 1 12-01-2023 03:00 PM
Default Currency format overidden when inserting a new row Can you have date and currency fields detect regional settings for format? mblackford Mail Merge 1 04-04-2019 03:38 PM
Default Currency format overidden when inserting a new row Why do currency cells automatically change to date format on some worksheets Hil Excel 1 09-16-2015 10:34 AM
Currency format in form travelred Word 2 11-14-2014 06:15 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:41 AM.


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