Copy date as 4 digit only

[Goddess]

Hi,

I have a field with date, eg 12/4/2012. I have formatted it to yyyy so it becomes just 2012. The problem is, I need to copy this "2012" to another sheet. It should show just "2012" and the cell is formatted as "General" due to some formula referencing to it in other cells. I tried few ways to paste the number, but it came out different. Is there anyway to do this?

Thanks,
Irene

 

[StephenCrump]

What about: =YEAR(Sheet1!A1)

 

[Goddess]

What about: =YEAR(Sheet1!A1)

Hi Stephen,

So sorry.. I wrongly phrase it as sheet.. I meant I need to copy to another file, so can't reference it to another file as it may cause some formula error if I don't email the source file.

Thanks for your reply!

 

[etaf]

do you need text YYYY - or can you just format that cell the same

as date is a number and then the MASK , shows the different formats

 

[StephenCrump]

It's not clear what/how you're copying from one workbook to the other.

If you're happy for the date to be unchanged, but continuing showing as 2012, then just format the cell the same, as @etaf says.

That means, for example, that if you are using Copy/Paste Values you should also do a Copy/Paste Formatting.