Forum Discussion

Excel's avatar
Excel
Iron Contributor
Jan 24, 2021

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

Hello 😊 How to Convert Ordinal number to Cardinal Number with the help of Formula or VBA? Like -  1st -- 1 2nd -- 2 3rd -- 3  and so on.   Please help..?? Waiting for your reply...???  
excel
Macros and VBA
Excel's avatar
Excel
Iron Contributor
Jan 24, 2021

Riny_van_Eekelen 

Yes sir... You are correct😊

Sir what if i want to change to -

22nd Dec - 22-Dec-2021(in date format)

Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Jan 24, 2021

Excel Not pretty, but like this:

=VALUE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(B13,"st ","-"),"nd ","-"),"rd ","-"),"th ","-"))

 

Resources