Show field as currency in Table View form

[JohnB47]

OK my system info is:

Version: 7.5.5.2 / LibreOffice Community
Build: caf8fe7424262805f223b9a233
Environment: CPU Threads: 4;OS: Windows 10.0 Build 19405
User Interface: UI render: Skia/Raster; VCL:win
Locale: en.GB (en_GB); UI: en-GB
Misc Calc: threaded

I have a form, with some data shown in a Table (Table View). There doesn’t seem to be a way for me to change one fields display to show as currency (eg £14.30) rather than as Decimal (14.30), which is what the field type is in the Table.

Is there a way to change the sql to show the fields output as currency, so that it’s fed into the form as £14.30? Or some other way?

Actually the same question applies if the field was displayed in a standard Text Box. How to display Decimal values as currency?

Thanks.

[RobertG]

Right mouse click on header of the table-control (in a form). Context menu → Replace with → Formatted Field. You could also chose Currency Field, but this field won’t show negatve values in red color. Right mouse click again. Context menu → Column → General → Formatting. Set formatting to currency by the button with 3 points […].

[JohnB47]

Excellent answer, and so quick too. Many thanks.