How remove date formatting but keep same numerals in order yyyymmdd

[xcellerator]

I have a file with a column for date (maybe 10k rows or so).
Within that column I would like all the cells to be unformatted and appear in the style 20231127 (order: year then month then date).

I have 3 different situations (at least...)
1.
Some of the cells are Format->Custom->yyyymmdd, and appear as 20231126, for example, but when I select the cell it appears as 11/26/2023
So, when I remove the formatting (which I think I would do by selecting the cell and then going to Edit->Clear-Formats), the date/number then changes into 45256.

2.
Some of the cells are Format->Custom->yyyymmdd, and appear as 20231125, for example, and when I select the cell it still appears as 20231125

3.
Other cells are Format->General, and appear as 20231124, and when I select the cell it appears as 20231124.

My goal is to remove the formatting for all dates and still have the cell appear as 20231126 (and not 45256). Sounds simple (and I'm sure it is...) but for the life of me I can't figure it out!
Thanks in advance of any help!

 

[eiloken]

you can use formula to split year, month, date and paste its as values:

=TEXT(YEAR("date"),"0000")&TEXT(MONTH("date"),"00")&TEXT(DAY("date"),"00")

 

[xcellerator]

Thank you @eiloken . That seems to work, but in the case where the formula is being applied to every row, and I do not know the format of the cell, if the cell has the data 20231125 in it and I use the formula, it will return #NUM! (case #3, above..and maybe #2 also?)

Is there a way to get it to "ignore" the data if it is already in the cell as 20231125 so I can leave those cells "as is" and will remain as 20231125 once I clear formatting?
Thank you again -

 

[Scott Huish]

=IF(--A1<19000101,--(TEXT(A1,"yyyymmdd")),--A1)