fixing distances to 3 decimal places when using Concatenate

Bobby1980

New Member
Joined
May 20, 2018
Messages
15
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
 

Some videos you may like

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
53,437
Office Version
365
Platform
Windows
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:
Code:
=CONCATENATE(A1,TEXT(B1,"0.000"))
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
53,437
Office Version
365
Platform
Windows
You are welcome.
 

Watch MrExcel Video

Forum statistics

Threads
1,099,353
Messages
5,468,118
Members
406,567
Latest member
ultrasuede

This Week's Hot Topics

Top