Excel has a feature that allows you to take a formula and convert it to text (copy and paste as a value) and I can’t find it in Numbers.
Trying to convert a value like “2022.12.04 07:50 AM” to date format 12/04/2022. I’ve used the functions CONCATENATE, MID, and LEFT to come up with what looks like it’s right but when I try to create a chart (line graph) it doesn’t work. I might be missing something in the graphing steps. Any help would be appreciated.
I’m trying to plot the data downloaded from my Wyze scale device. X= date and Y=weight. Should be a simple X-Y plot.