Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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?

share|improve this question

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.