if calculate any thing like: 5/2 then the result show 2.5. here I want the result show is 3. I mean if it is over .5 then it show the ground figure not show decimal. if is 2.4 then it show 2. please any body help me. i did it like 2 by change the format but if i want to show it like 2.00 (with decimal place) then it not show.
abu taher
34
Practically a Posting Shark
Recommended Answers
Jump to Postyou want the cell to display in decimal places, try formatting the cell to accounting format.
if you're using office 2007 right click on a cell you to format then choose Format Cells on Number tab choose Accounting.
Jump to PostHi abutaher, check out this site to format a cell: http://www.ehow.com/how_11799_format-cell-numbers.html
Jump to Postcheck out the attachment
Jump to PostYou could use a custom format
0."00"
But I can't really understand why you would want to put two zeros after your decimal point while they aren't correct.
All 14 Replies
cguan_77
8
Nearly a Posting Virtuoso
abu taher
34
Practically a Posting Shark
cguan_77
8
Nearly a Posting Virtuoso
abu taher
34
Practically a Posting Shark
cguan_77
8
Nearly a Posting Virtuoso
abu taher
34
Practically a Posting Shark
cguan_77
8
Nearly a Posting Virtuoso
abu taher
34
Practically a Posting Shark
cguan_77
8
Nearly a Posting Virtuoso
abu taher
34
Practically a Posting Shark
cguan_77
8
Nearly a Posting Virtuoso
Notiz Me
0
Newbie Poster
abu taher
34
Practically a Posting Shark
Notiz Me
0
Newbie Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.