Share
Report
10Hello everyone,
I have a question regarding a form. In this form I want to display prices for a product. I have formatted these prices for the different products in my data source (Excel spreadsheet) as "Standard". However, for some products no price is known, here I would like that in this case "No specification" is displayed. This is also entered in my data source. I have now found a formula on Google to display numbers as currency. This works well in one form, with fewer entries, but not in another form, where the data source is somewhat larger, but the data is the same. Also the display of the text "no specification" does not work here. I have captured it in two screenshots:
the two data sources are formatted in the same way. All entries in the data sources are formatted to default in Excel. I don't understand why it keeps showing me error messages there. The second image is for the table with the smaller data source. There it converts the numbers (but still shows an error message that the value 107.500€ cannot be converted to a number), but here it does not show "no specification" as text. With the larger table this works, but here it does not convert the numbers.
I hope it is formulated reasonably understandable and that someone can help me there.
Thanks in advance and best regards
Lennart
Categories:
All responses (
Answers (
