Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-10-2021, 04:59 PM
melburn melburn is offline Custom cell formatting Windows 7 32bit Custom cell formatting Office 97-2003
Novice
Custom cell formatting
 
Join Date: Jul 2019
Posts: 6
melburn is on a distinguished road
Default Custom cell formatting

I am puzzled at to why Display or hide zero values - Excel defines 0;-0;;@, as the Custom format for cells to display zero as an empty cell.



The '@,' suffix serves no obvious purpose, the zero cells display empty with or without it.

The page at Excel custom number formats | Exceljet defines @ as "Placeholder for text", but there is no description about how one can make use of it. The example given does not help because in the tests I ran, text in a numeric cell displayed in blue both with and without the @.

- What does the @ contribute to a cell display?
- What purpose does the trailing comma serve?
Reply With Quote
  #2  
Old 07-14-2021, 11:42 PM
xor xor is offline Custom cell formatting Windows 10 Custom cell formatting Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,078
xor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of light
Default

0.00; -0.00;; [Red]@ - applies the red font color for text values. If you omit the @ Excel will automatically change the custom format to 0.00; -0.00;; [Red]Standard. Result is the same. I think the trailing comma is an error.
Reply With Quote
  #3  
Old 08-01-2021, 12:34 AM
melburn melburn is offline Custom cell formatting Windows 7 32bit Custom cell formatting Office 97-2003
Novice
Custom cell formatting
 
Join Date: Jul 2019
Posts: 6
melburn is on a distinguished road
Default

Thank you, much appreciated.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formatting unprotected cell in protected w/s makes the cell locked? tango356 Excel 2 01-23-2017 02:13 PM
Pasting text from Excel cell into word without creating a table, and keeping the in-cell formatting hanvyj Excel Programming 0 08-28-2015 01:15 AM
Custom cell formatting Question re: Conditional formatting (cell occurs after another cell) Saywarder Excel 1 04-20-2015 11:29 AM
Conditional Cell Formatting: Alternating Cell Checks corbott Excel 4 12-16-2014 01:51 PM
How can I fill cell color starting from Cell D5 using Conditional formatting instead Learner7 Excel 0 07-08-2010 05:50 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:45 AM.


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