Converting Japanese dates to Western ones and vice versa

[RedBeard]

A bit of an odd one.
I've been working with a Japanese Excel sheet where the dates are all in the Japanese style.

That is, 2015 would be displayed as 平成27.

Now, I have been searching and having found nothing, come to ask for help here.

Is there a built in converter for western dates to Japanese ones and vice versa, or is this something one must do manually?

Grateful for any and all assistance.

 

[RudiS]

Would it not just be a locale setting you can change?

See this image...

 

[RedBeard]

Would it not just be a locale setting you can change?

See this image...

That's very useful, thank you.

But can I call this functionality via a macro somehow?

 

[My Aswer Is This]

Use your Macro Recorder then look at the script and copy the portion you need and put that into your vba script.

 

[RedBeard]

And the simple solution is the best one.

Thanks, why did I forget about the macro recorder?

 

[My Aswer Is This]

There are always more then one way to skin a cat.

And the simple solution is the best one.

Thanks, why did I forget about the macro recorder?