I have data in a LibreOffice Calc spreadsheet with penny values, such as 001234 to represent $12.34 (twelve dollars and thirty-four cents). How can I define a format that will display these values as standard USD currency? Alternatively, what's a quick way to manipulate all of those values so that they act as USD currency, e.g. divide each by 100?
An answer on another question suggested using
#0\.00 as the format code, but this fails to handle thousands separators.
As another alternative, is there a way when Opening the data file (defined as a Fixed width file, not CSV) to specify that the field contains numbers that should be understood as having two decimal places?