April 5, 2022
Column A has a list of dates (e.g. 17/01/2022, 18/01/2022 ...) with associated underlying serial numbers (e.g. 44578,44579 ...) The dates in Column A are presented in a second column (B) in yyyymmdd format (e.g. 20220117, 20220118 ...)
How do I present the yyyymmdd data presented in Column B in the form of 'one for one' equivalent numbers, without the serial number format?
Instead of having cells in column B with a date 20220117, I would like the cells to present the number 20220117 (i.e. 20,220,117) without the underlying serial number.
Currently, I can only achieve the above outcome by deleting the original date and physically typing the equivalent number value (20220117) into the cell in General format (this gives me the number without the comma's and without the Date format)
Any help is greatly appreciated.
July 16, 2010
April 5, 2022
Many thanks for your solution - all is good !!!
I greatly appreciate the promptness of your reply and that you have personally taken the time to help me with a solution.
I've viewed some of your Youtube dashboard tutorials and have been very impressed with their clarity and thoroughness. It was a Google search that led me to your My Online Training site and the Youtube experience (and Australian location) that prompted me to post my question.
Once again, many thanks.