Formating 2005345 to only 34!

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

a94andwi - 01 Sep 2005 15:49 GMT

Hello I got this date 2005345 which means year 2005, week 34, day 5
I want excel to format these values 2005345 and only show W34
How is this possible?

/Anders

Signature

a94andwi

Reply to this Message

Roger Govier - 01 Sep 2005 16:12 GMT

With data in A1 try
="W"&MID(A1,5,2)

Signature

Regards

Roger Govier

> Hello I got this date 2005345 which means year 2005, week 34, day 5
> I want excel to format these values 2005345 and only show W34
> How is this possible?
>
> /Anders

Reply to this Message