[Show all top banners]

Back to: Kurakani General

Refresh page to view new replies Enter your email and submit: You will be notified when someone replies to this thread     PLEASE ENTER VALID EMAIL!

[VIEWED 3733 TIMES] SAVE! for ease of future access. LOG IN TO ACCESS THIS FEATURE. Or you can enter your email here to get the link emailed to you

View User Profile View User Postings logan Please log in to subscribe to logan's postings. Posted on 07-29-21 2:38 PM     Reply [Subscribe]

Login in to Rate this Post:     0       ?

When I copy a cell that is formatted for Date has date it will copy that date. If blank instead of 0 it gives 1/0/1900. Is there any formula that will give me 0 when to be copied cell is blank and if there is value copies the value. Last edited: 29-Jul-21 03:56 PM View/Share this post only

Your Banner Here

View User Profile View User Postings HelpYouHelpMe Please log in to subscribe to HelpYouHelpMe's postings. Posted on 07-30-21 4:54 PM     [Snapshot: 155]     Reply [Subscribe]

Login in to Rate this Post:     0       ?

Logan, copy the following formula from cell B7 to the cells in column B: =IF(ISBLANK(A7),"0",A7) View/Share this post only

View User Profile View User Postings logan Please log in to subscribe to logan's postings. Posted on 08-02-21 8:51 AM     [Snapshot: 350]     Reply [Subscribe]

Login in to Rate this Post:     0       ?

Thank you, View/Share this post only

---

Please Log in! to be able to reply! If you don't have a login, please register here.

Recommended Popular Threads

Controvertial Threads

TPS Re-registration case still pending .. Toilet paper or water? ढ्याउ गर्दा दसैँको खसी गनाउच Tourist Visa - Seeking Suggestions and Guidance To Sajha admin From Trump “I will revoke TPS, and deport them back to their country.” wanna be ruled by stupid or an Idiot ? MAGA denaturalization proposal!! advanced parole How to Retrieve a Copy of Domestic Violence Complaint??? and it begins - on Day 1 Trump will begin operations to deport millions of undocumented immigrants Travel Document for TPS (approved) All the Qatar ailines from Nepal canceled to USA

NOTE: The opinions here represent the opinions of the individual posters, and not of Sajha.com. It is not possible for sajha.com to monitor all the postings, since sajha.com merely seeks to provide a cyber location for discussing ideas and concerns related to Nepal and the Nepalis. Please send an email to admin@sajha.com using a valid email address if you want any posting to be considered for deletion. Your request will be handled on a one to one basis. Sajha.com is a service please don't abuse it. - Thanks.