Date of worksheet comes out numbers on other linked worksheet

[Deb A]

The main worksheet has total 10 column/projects. Each column/project has a
separate worksheet. I copied the column/project from the main worksheet and
then did a "paste link" onto the separate worksheet so that anything on the
main worksheet that changes will automatically update on the individual
worksheet.

Question #1: The date field shows up as numbers on the separate worksheet
and not the date that is on the main worksheet. What formula is needed that
will automatically be posted on the separate worksheet?

Question #2: What formula is needed for the separate worksheet cell to be
blank?

I hope this makes sense.

 

[Mike H]

Hi,

Q1. The cell sounds like it is formatted as General so fromat as a date.

Q2. I don't understand the question.

Mike

 

[Gord Dibben]

1. Format the cells on the other sheets as Date

2. =IF(Sheet1!A1="","",Sheet1!A1)

You cannot create the formula using "paste link"

You must enter it then copy down and across in target sheet.


Gord Dibben MS Excel MVP