Change in reverse order

[paradise2sr]

Hi,

I have some data in the below format :

01/04/2078

I want the result in below format :

2078/04/01

How this can be achieved ?

[Abith]

if the data you mentioned are dates, you can do this

=+TEXT(L38,"YYYY/MM/DD")

[Fluff13]

Another option is to use cell formatting, which will keep the values as dates, rather than text.

[paradise2sr]

Thanx for it.

In addition to it,I want further to change in another format as well.

From,

01/04/2078

to below format :

2078.04.01

[AliGW]

Try this:

=TEXT(L38,"YYYY.MM.DD")

[janmorris]

your use of both month and day below 12 makes it unclear what you want.

it is formatting either as:
yyyy.mm.dd

or
yyyy.dd.mm

[paradise2sr]

Try this:

=TEXT(L38,"YYYY.MM.DD")

Thanx it worked.