ExcelBanter - concatenate number format issue

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - concatenate number format issue (https://www.excelbanter.com/excel-worksheet-functions/18425-concatenate-number-format-issue.html)

Tim Elhatton

concatenate number format issue

Hi the

cell d21 is formatted to currency/zero decimals and contains the value $4,104

cell k10 is formatted to general

in cell k10 I put the following formula
=concatenate("<",d21)
the result in cell k10 is <4103.559020548

I would like to see just <4104

Can someone help? Thanks very much

GaryDK

Hi Tim,

This should do it -

=CONCATENATE("<",ROUND(D21,0))

Gary

Debra Dalgleish

In cell K10, you can use the TEXT function to format the number:

="<" & TEXT(D21,"0")

Tim Elhatton wrote:
Hi the

cell d21 is formatted to currency/zero decimals and contains the value $4,104

cell k10 is formatted to general

in cell k10 I put the following formula
=concatenate("<",d21)
the result in cell k10 is <4103.559020548

I would like to see just <4104

Can someone help? Thanks very much

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Tim Elhatton

Thanks Gary.....that's got it.....
Tim

"GaryDK" wrote:

Hi Tim,

This should do it -

=CONCATENATE("<",ROUND(D21,0))

Gary

John Mansfield

Tim,

Try,

=CONCATENATE("<",TEXT(D21,"###"))

----
Regards,
John Mansfield
http://www.pdbook.com

"Tim Elhatton" wrote:

Hi the

cell d21 is formatted to currency/zero decimals and contains the value $4,104

cell k10 is formatted to general

in cell k10 I put the following formula
=concatenate("<",d21)
the result in cell k10 is <4103.559020548

I would like to see just <4104

Can someone help? Thanks very much

All times are GMT +1. The time now is 06:43 PM.