Only leave 4 digins after the point

[WelshyWizard]

I'm looking to take a value, for example 9383.121459 and change the value to 9383.1214 (for digits after the point)

I don't want to round the value to 4 decimal places, just simply cut off the digits after the the 4th digit.

Also, not all values will have the same number of digits to start... For example the value couls be 12, 12.343, 12.2 etc....

Any one have any ideas?!

Cheers

Today is the tomorrow you worried about yesterday - and all is well.....

 

[Loomah]

Hi
Have a look at the TRUNC function.

;-)

If a man says something and there are no women there to hear him, is he still wrong?
How do I get the best answers?​

 

[PHV]

Something like this ?
NewVal = Int(10000 * OldVal) / 10000

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[firefytr]

Also..

=ROUNDDOWN(A1,4)

-----------
Regards,
Zack Barresse

 

[PHV]

=ROUNDDOWN(A1,4)
How do you use this in VBA ? ;-)

 

[firefytr]

Hehe, sorry..

WorksheetFunction.RoundDown(Workbooks("Book1.xls").Sheets("Sheet1").Range("A1"), 4)

Of course, depending on your situation should dictate how you need to reference the workbook/worksheet.

-----------
Regards,
Zack Barresse