using formula on linked cells from two different worksheets

[Matt0922]

Hello!

I need to be able to keep a destination cell on a separate worksheet blank if there's no entry from the source sheet on a different worksheet. However, if there's an entry, and likely a Date, I would for the both source and destination cells to have the following format 000000 so that a date is appear as such: 050216.

So far, i have been able to keep destination cells blank if the source cell is blank using the following format (on the destination cell) which I got from one of the posts (not on this site):
0;-0;;@
The problem is that, when there's an entry, and in this case it's a date, on my source sheet it appears as 050216 but on the destination cell, it appears as 50216.

Can someone please help me?
Thanks!

 

[Joe4]

You had posted this in the Microsoft Access forum even though it appears to be an Excel question. So I have moved it to the Excel Questions forum.

So far, i have been able to keep destination cells blank if the source cell is blank using the following format (on the destination cell) which I got from one of the posts (not on this site):
0;-0;;@

If you are posting the same question on multiple sites, please note our rules on Cross-Posting.

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule #13 here: Forum Rules).

This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

For a more complete explanation on cross-posting, see here: Excelguru Help Site - A message to forum cross posters).

 

[Matt0922]

I didn't post this question anywhere else. Sorry if I was not clear. I read a few tips but none were helpful.

 

[Joe4]

Does a formula option like this work instead?

=IF(Sheet1!A1="","",TEXT(Sheet1!A1,"000000"))