Eliminate zeros in linked fields 2

[tj63069]

Good Morning

I have a linked Excel Spreadsheet. the source spreadsheet has one column for the user to pencil in a count of the inventory counts. How can I get rid of the zero in the receiving spreadsheet so the field is blank?

 

[SkipVought]

hi,

Use Conditional Formatting to format ZEROS the same shade as the cell interior.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[mltoombs]

Here is something else that would work as well -> =IF(Sheet1!A2<>" ",Sheet1!A2,"")

 

[Deniall]

There are plenty of ways to skin a dead cat.

You could also use a custom numerical format.
FormatCells > Number > Custom
then feed in the string
#,##0;-#,##0;
where the final semi-colon is important and the minus sign can be even more important.[&nbsp;] (This assumes that you are restricting yourself to integer numbers.[&nbsp;] If not, minor changes are required.)

I often use a variant of this, where I like a small marker instead of the zero.[&nbsp;] I use the "·" character (ANSII code = 0183), and so the custom string becomes
#,##0;-#,##0;"·"
The use of the · character serves two purposes.[&nbsp;] It confirms for me that the cell is not empty, while not being as visually obtrusive as the 0 character.[&nbsp;] In a tabular layout the presence of the marker rather than blank space helps to emphasise the tabular presentation and to guide the eye in following the rows and columns if the table is heavily populated with zeroes.