If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)

Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Excel Custom Format

JJJackal · 2019-06-12 18:21:04

Hi All, I have the following in a single text box in excel: (-0.02934,-0.02161) I want to custom format this single box to look like: (-0.029,-0.022) Does anyone know the code for the custom format to do this? Much thanks

Options

12-06-2019 7:21pm

#1

JJJackal

Registered Users Posts: 1,016 ✭✭✭

Join Date: February 2019

Posts: 997

Hi All,

I have the following in a single text box in excel:

(-0.02934,-0.02161)

I want to custom format this single box to look like:

(-0.029,-0.022)

Does anyone know the code for the custom format to do this?

Much thanks

0

Comments

Options
#2 12-06-2019 9:11pm
JJJackal

Registered Users Posts: 1,016 ✭✭✭

Join Date: February 2019

Posts: 997

="("&ROUND(MID(F41,2,FIND(",",F41)-2),3)&", "&ROUND(MID(F41,FIND(",",F41)+1,LEN(F41)-FIND(",",F41)-1),3)&")"

This will do the trick

Found it on another forum

0
Options
#3 12-06-2019 9:44pm
smuggler.ie

Registered Users Posts: 4,130 ✭✭✭

Join Date: October 2015

Posts: 4080

If this is output of CONCATENATE from two cells, you could do:
=CONCATENATE(TEXT(A1,"0.000")&","&TEXT(B1,"0.000"))

0