Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Hi Tim,
This should do it - =CONCATENATE("<",ROUND(D21,0)) Gary |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
Thanks Gary.....that's got it.....
Tim "GaryDK" wrote: Hi Tim, This should do it - =CONCATENATE("<",ROUND(D21,0)) Gary |
#5
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I format a cell for a custom part number? | Excel Discussion (Misc queries) | |||
Telephone number format | Excel Discussion (Misc queries) | |||
How to format a number in Indian style in Excel? | Excel Discussion (Misc queries) | |||
How do i change numbers in text format to number format? | New Users to Excel | |||
GET.CELL | Excel Worksheet Functions |