#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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.
|
#3
|
|||
|
|||
Thank you, much appreciated.
|
|
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 |
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 |