fixing distances to 3 decimal places when using Concatenate

[Bobby1980]

Hi there,

when using the Concatenate() command, was wondering how you go about making the distances only show 3 decimal places.

EG at current I have CONCATENATE(BEARING,BEARING SYMBOL,MIN,,,SECS,"~10.000000112)

Any help would be greatly appreciated,




Warmest Regards,

Rob

 

[Joe4]

Whatever part has the number, use the Text function to specify the decimal places.

For example, if A1 contains: "The Length is: "
and B1 contain: 10.500
then your formula would look like:

=CONCATENATE(A1,TEXT(B1,"0.000"))

 

[Bobby1980]

Thank you Kindly for your reply, will give this a try

 

[Joe4]

You are welcome.