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

Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

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

12-06-2019 6:21pm

#1

JJJackal

Registered Users, Registered Users 2 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

#2 12-06-2019 8:11pm

JJJackal

Registered Users, Registered Users 2 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
#3 12-06-2019 8:44pm

smuggler.ie

Registered Users, Registered Users 2 Posts: 4,269 ✭✭✭

Join Date: October 2015

Posts: 4217

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

0