Convert Ordinal to Cardinal number with the help of Formula or VBA code.

Question

Hello 😊How to Convert Ordinal number to Cardinal Number with the help of Formula or VBA?Like -&nbsp;1st -- 12nd -- 23rd -- 3&nbsp;and so on.&nbsp;Please help..??Waiting for your reply...???&nbsp;

riny_van_eekelen · Answer

Excel&nbsp;Perhaps like this?

excel · Answer

Riny_van_Eekelen&nbsp;Yes sir... You are correct😊Sir what if i want to change to -22nd Dec - 22-Dec-2021(in date format)

riny_van_eekelen · Answer

Excel&nbsp;Not pretty, but like this:=VALUE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(B13,"st ","-"),"nd ","-"),"rd ","-"),"th ","-"))&nbsp;

excel · Answer

Riny_van_Eekelen&nbsp;Thank you so much sir😊&nbsp;

riny_van_eekelen · Answer

Excel&nbsp;You're welcome!

Forum Discussion

Convert Ordinal to Cardinal number with the help of Formula or VBA code.

5 Replies

Resources