Forums
New posts
Articles
Product Reviews
Policies
FAQ
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Menu
Log in
Register
Install the app
Install
Forums
General Discussions
Switcher Hangout (Windows to Mac)
Where do I get a Spread Sheet to do the following?
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="Slydude" data-source="post: 1761027" data-attributes="member: 131855"><p>I don't have Open Office installed anymore so I'll give the solution yo you the way it is done in Excel. As I recall Open Office is either identical or so close you should be able to find the right command.</p><p></p><p>1. Select the numbers that need to have the decimal point and 00</p><p>2. Right click the selected area and choose <strong>Format cells</strong> (or go to the <strong>Format</strong> menu and choose <strong>cells</strong>)</p><p>3. In the formatting sheet that appears click on the <strong>Numbers</strong> tab. Then, on the left side of the box choose<strong> Currency</strong>. In the smaller box on the right choose one of the options with the .00 included then click OK</p></blockquote><p></p>
[QUOTE="Slydude, post: 1761027, member: 131855"] I don't have Open Office installed anymore so I'll give the solution yo you the way it is done in Excel. As I recall Open Office is either identical or so close you should be able to find the right command. 1. Select the numbers that need to have the decimal point and 00 2. Right click the selected area and choose [B]Format cells[/B] (or go to the [B]Format[/B] menu and choose [B]cells[/B]) 3. In the formatting sheet that appears click on the [B]Numbers[/B] tab. Then, on the left side of the box choose[B] Currency[/B]. In the smaller box on the right choose one of the options with the .00 included then click OK [/QUOTE]
Verification
Post reply
Forums
General Discussions
Switcher Hangout (Windows to Mac)
Where do I get a Spread Sheet to do the following?
Top