Excel formatting

  • Thread starter Thread starter Stacy Taylor
  • Start date Start date
S

Stacy Taylor

When you have two sheets in one workbook linked together
and on the original you have no entry in the cell, how do
you get rid of the "0" that appears on the linked sheet?
 
Hi Stacy
you may use the following formula in cell A1 on the second sheet (where
sheet1 is the linked sheet)
=IF('sheet1'!A1="","",'sheet1'!A1)
copy down/to the right
 
Stacy

You can also go to menu, tools, options, view tab and
uncheck the zero option box.

Charlie O'Neill
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

enter key behavior - by sheet 4
Unwanted workbooks on startup 2
Excel Move or Copy Stopped Working? 0
Macro to Combine Data from Multiple Sheets with Cell References 4
Delete sheets code error requires object 2
Export Sheet Values to new workbook 20
Excellent code now a question of Feasibility 7
Excel Macro to un-mute Audio/speakers. 15

Back
Top