Log In
Register
Home
New Member
Power Query
April 5, 2022
Offline
Hi
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.
See Answer
July 16, 2010
Offline
Hi Graham,
Welcome to our forum! You can use the following formula to convert the date serial numbers to text and then back to a number:
=VALUE(TEXT(A1,"yyyymmdd"))
Mynda
Answers Post
New Member
Power Query
April 5, 2022
Offline
Hi Mynda
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.
Regards
Graham
1 Guest(s)
