How to convert the right number of decimals in a numberformat from Excel to Word

P

Per Roar Øgaard

I make advanced Excel sheets at home; and use them at my work.
When I am nesting information within a numberformat with 2 decimals (ex;
3,72) from Excel, into a MS Word document; the result
shows a lot of decimals (ex; 3,72229953).

If you know how to solve this; I will be very happy if you will share the
solution !
I want the same decimal-numberformatting in Word as in Excel.
It is to much work to solve this with manually deleting the overflowing
decimals.


--

Med hilsen

Per R.
[email protected]
 
T

Trevor Shuttleworth

This example might help:

Sub test()
Range("A1") = 3.72229953
MsgBox Range("A1").Value
MsgBox Range("A1").Text
End Sub

Regards

Trevor
 
Top