Microsoft Office Forums

Go Back   Microsoft Office Forums > >

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



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 03:44 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