kserei kaneis pos ginete ayto sto excel??

[sosimple]

Kserei kaneis pos ginete ena apotelesma na vgenei me 2 mono dekadika psifia??

Diladi, to 5,675 na ginete 5,68 eno to 5,674 na ginete 5,67 ?

kai oloi oi oipologismoi pou ginonte meso excel na ginonte me 2 dekadika psifia me vash

ton parapano kanona.

Please an kapoios to kserei as apantisei,thanks.

[Lefki]

Apo to help tou Excel:

 

A.

1.Select the cells you want to format.

 

2.To display more or fewer digits after the decimal point, click Increase Decimal or Decrease Decimal on the Formatting toolbar.

--------------------------------------

B.

In a built-in number format

 

1.On the Format menu, click Cells, and then click the Number tab.

 

2.In the Category list, click Currency, Accounting, Percentage, or Scientific.

 

3.In the Decimal places box, enter the number of decimal places you want to display.

 

------------------------

An diskoleuesai me ta agglika(i exeis elliniko excel) grapse sto assistant (help) tou excel tin lexi "dekadika:

 

<img border="0" title="" alt="[Roll Eyes]" src="images/icons/rolleyes.gif" /> <img border="0" title="" alt="[Roll Eyes]" src="images/icons/rolleyes.gif" /> <img border="0" title="" alt="[Roll Eyes]" src="images/icons/rolleyes.gif" />

[or1onas]

Ektos apo to formatting twn cells gia ton ari8mo twn dekadikwn pshfiwn, fantazomai oti 8a xreiasteis k mia apo tis ROUNDUP h ROUNDDOWN Functions, oi opoies strogylopoioyn pros ta panw h pros ta katw antistoixa... h xrhsh tous einai poly aplh:

roundup ('ari8mos keliou','strogylopoihsh se tosa pshfia')

px. roundup(A4,2)-> strogyllopoihsh pros ta anw tou keliou A4 sta dyo dekadika pshfia.... h

px. rounddown(B8,1)-> strogyllopoihsh pros ta katw sto prwto dekadiko pshfio....

elpizw na boh8hsa...rixe pantws k sy an 8es mia matia sto help tou excel , einai poly kalo...

<img border="0" title="" alt="[smile]" src="images/icons/smile.gif" />

[sosimple]

eyxaristo poli paidia,ta katafera telika.

Ayto pou epsaxna htan afto pou mou eipe o filos or1onas.

Sinkekrimena gia opion psaxnei kai aftos to idio, h entoli einai

round( ;2) kai sou strogilopoih me 2 dekadika psifia simfona me

ton kanona pou anefera.File Lefki afto pou mou eipes esi,to iksera.

nai men kanei to idio sthn othonh tou eipologisth,ala gia tous parapera

ypologismoun krataei ta noumera me ola ta dekadika psifia,diladi apla ta emfanizei

me 2 dekadika,DEN ta metatrepei sta alithia,opote oi parapera oipologismoi einai

diaforetikoi me tous 2 parapano tropous...