concatenate number format issue

[Tim Elhatton]

Hi there:

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]

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

 

[John Mansfield]

Tim,

Try,

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