Forum Discussion
How to get a dropdown list of numbers, not dates?
When you paste the value in cells its automatic formatting changes it to numbers and we need to explicitly store it as text.
There are two way to deal with this issue:
Type an apostrophe (') at the beginning of each entry if you have limited values.
'2025-04-01 10:00 '2025-04-01 10:30this store the value as text
Formula version which is more effective for larger dataset, add helper column and use the function TEXT() to convert these values into text and reference dropdown list to the helper column.
=TEXT(A2,"yyyy-mm-dd hh:mm:ss")
Solution with TEXT()If this resolves your query don't forget Mark as Solution.
When you paste the value in cells its automatic formatting changes it to numbers and we need to explicitly store it as text.
There are two way to deal with this issue:
Type an apostrophe (') at the beginning of each entry if you have limited values.
'2025-04-01 10:00
'2025-04-01 10:30this store the value as text
Formula version which is more effective for larger dataset, add helper column and use the function TEXT() to convert these values into text and reference dropdown list to the helper column.
=TEXT(A2,"yyyy-mm-dd hh:mm:ss")Solution with TEXT()
If this resolves your query don't forget Mark as Solution.
Type an apostrophe (') at the beginning of each entry if you have limited values.
Type an apostrophe (') at the beginning of each entry if you have limited values.
https://www.reddit.com/r/accidentallygay/comments/1jb2kng/new_monopoly_go_free_dice_rolls_links_daily/ https://www.reddit.com/r/accidentallygay/comments/1jb2l5d/updatedway_how_to_best_500_free_dice_links_in/ https://www.reddit.com/r/accidentallygay/comments/1jb2lin/eightways_5000_free_dice_monopoly_go_rolls_links/ https://www.reddit.com/r/accidentallygay/comments/1jb2lxr/new_monopoly_go_free_dice_rolls_links_march_2025/ https://www.reddit.com/r/accidentallygay/comments/1jb2mqk/heres_how_to_get_thousands_of_monopoly_go_free/ https://www.reddit.com/r/accidentallygay/comments/1jb2n6b/heres_how_to_get_monopoly_go_free_dice_links_2025/
