Note that this solution will look like a number but it will actually be a text string. If you need the value to behaving like a number, you will need to wrap it in the
Note that some operations such as sorting can be done on text strings, but other operations such as adding or multiplying need to be done on a number.
OK, Kelly, breathe, breathe… Try not to freak out that Kuovonne, of the September virtual conference and other videos fame, just answered your question!!!
Hey Kuovonne, thanks! Yes, I just want to use the date as the invoice number, but appreciate your feedback and have been wanting to learn more about the VALUE function.
Oh dear. :blush: Don’t freak out. I’m just a human like anyone else.
I’ve learned a large part of what I know because other people in this community have been generous in sharing their knowledge.
If you want to learn more about
VALUE(), it is explained in the formula field reference, as the last entry under Numeric functions.
Thanks Kuovonne :slightly_smiling_face: I really admire how you taught yourself so much and so well! You’ve been very inspiring in the videos I’ve seen. That project with the book about plants? Amazing.