Formating the cell

T

TaGY2K

Ok.. why is when I change the format from:

742.868
328.244
466.452

to

742.87
328.24
466.45

and then when I copy and paste it shows:

742.87
328.24
466.45

but when I export it to access it should up like this:

742.868
328.244
466.452

so how do I change it so it only should

742.87
328.24
466.45
 
R

RagDyer

Because formatting doesn't change any values, it just changes the *display*
of the values.
You could round your formulas so that the cells actually contain the values
that you wish to display.

For example, if:
=A1*B1
would return 742.868,

You could revise the formula to:

=ROUND(A1*B1,2)

So that the cell would actually contain the value of
742.87
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
 
Top