Number Format #2

[mars]

Hello
Can't get this formula to work with 1999/00 - should read 01/07/2000
instead shows 01/07/1900


="31"&"/"&"1"&"/"&LEFT(B3,2)&RIGHT(B3,2)

Much obliged if you can help....


Mars

 

[James Ravenswood]

Hello
Can't get this formula to work with 1999/00 - should read 01/07/2000
instead shows 01/07/1900

="31"&"/"&"1"&"/"&LEFT(B3,2)&RIGHT(B3,2)

Much obliged if you can help....

Mars

On my machine, it shows:

31/1/1900

 

[Junge]

Try
="01"&"/"&"07"&"/"&Left(B3,4)+1 - or "01/07/"&Left(B3,4)+1
or for end of year?
="30"&"/"&"06"&"/"&Left(B3,4)+1 - or "30/06/"&Left(B3,4)+1
Junge

 

[mars]

All
Many thanks for your replies and apologies for the error in my
message.

Junge, your offer worked!


Mars