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.