When i add money signs to the numbers down column B it does something with the Function Wizard and i just get a bunch of pound signs. I’ve never used Libre Office before and I’m a little lost.
The # is displaying because the width of the the column is less than necessary to display the data:
Widen the the column (drag right edge in label area):
or right click column label and select Column width.
Here is the location for LO documentation - click here.