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

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
53,650
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,650
Office Version
365
Platform
Windows
You are welcome.
 

Watch MrExcel Video

Forum statistics

Threads
1,102,351
Messages
5,486,356
Members
407,541
Latest member
Emilybuhman

This Week's Hot Topics

Top