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

[Excel]

Hello :smiling_face_with_smiling_eyes:

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...???

[#2]

@Excel Perhaps like this?

[#3]

@Riny_van_Eekelen 

Yes sir... You are correct:smiling_face_with_smiling_eyes:

Sir what if i want to change to -

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

[#4]

@Excel Not pretty, but like this:

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

 

[#5]

@Riny_van_Eekelen 

Thank you so much sir:smiling_face_with_smiling_eyes:

[#6]

@Excel You're welcome!