Forum Discussion

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

Riny_van_Eekelen

Platinum Contributor

Jan 24, 2021

Excel Perhaps like this?

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
  Platinum Contributor
  Jan 24, 2021
  Excel Not pretty, but like this:
  =VALUE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(B13,"st ","-"),"nd ","-"),"rd ","-"),"th ","-"))
  - Excel
    Iron Contributor
    Jan 24, 2021
    Riny_van_Eekelen
    Thank you so much sir😊