View Single Post
  #1   Report Post  
Tim Elhatton
 
Posts: n/a
Default 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