In all versions of Excel, press Control + 1 in the numbers row. This
will bring up the format dialog. Make sure you are in the Numbers tab.
If not, use the left and right arrow keys to get there. Unless you have
gone to this dialog before, it should be on this tab. Tab to the list of
formats and select number or currency instead of general. These two
formats have the option to set the number of digits after the decimal
point to use. Tab around this dialog, it provides many options. You can
even customize it to create your own format.
*Don Marang*
Vinux Software Development Coordinator - vinuxproject.org
<http://www.vinuxproject.org>
There is just so much stuff in the world that, to me, is devoid of any
real substance, value, and content that I just try to make sure that I
am working on things that matter.
-- Dean Kamen
On 31/03/11 08:47, Cliff Smales wrote:
I'm using Excel a great deal, these days, and have a question.
Whenever I have a calculation, Excel carries the decimal point out to four or
five places. How can I get the program to go two places, at the most?
Cliff Smales
For answers to frequently asked questions about this list visit:
http://www.jaws-users.com/help/
Send any questions regarding list management to:
[email protected]
For answers to frequently asked questions about this list visit:
http://www.jaws-users.com/help/
Send any questions regarding list management to:
[email protected]
