I am doing = some cell from another table to create another set of data, In some cases the cells I am copying are blank, but they show up as a 0 by doing this. How to make them blank?
Thanks for the help.
You could do...
=IF(C5="","",C5)
or you could apply a custom format to just hide the 0.
0;;;@
HTH
Regards, Jeff
If you like the answer(s) provided, why not add some reputation by clicking the * below
Please use [ Code ] tags when posting [ /Code ]
Please view/read the Forum rules --- How to mark a thread as solved
Hi
Go to Excel option-->Advanced then under "Display options for this worksheet" unselect "show zeros in cells that have zero value" this will hide the zeros for the selected worksheet
Thanks much, that worked great.
You're welcome…Thanks for the follow up and glad it worked for you...
If you are satisfied with the answer provided, please don’t forget to mark the thread as solved.
How to mark a thread Solved
Go to the first post
Select
-- Edit
-- Go Advanced
-- Below the word Title you will see a dropdown with the word No prefix
-- Update to Solved and then select Save
HTH
Regards, Jeff
If you like the answer(s) provided, why not add some reputation by clicking the * below
Please use [ Code ] tags when posting [ /Code ]
Please view/read the Forum rules --- How to mark a thread as solved
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks