Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CONCATENATE zeros
I am trying to calculate only change and not dollars and then see if
the change balances... This works…. K6 = 4 Q:12 sum(A1:A12) - this yields $10.40 Q13 =CONCATENATE(RIGHT(Q12,1)) - this yields the 4 Q14 =IF(K6<Q13,"Balance","Out") this yields Balance BUT This does not with whole numbers… K6 = 0 Q:12 sum(A1:A12) - this yields $16.00 Q13 =CONCATENATE(RIGHT(Q12,1)) - this yields the 6 Q14 =IF(K6<Q13,"Balance","Out") this yields Out where it should balance as there are no cents. It seems that Excel does not seeing zero cents and thus jumps a decimal place. Any help anyone could give me would be greatly appreciated! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Concatenate with leading zeros | Excel Worksheet Functions | |||
How can I concatenate text with leading zeros | Excel Worksheet Functions | |||
Concatenate Text & Numbers Keeping zeros.. | Excel Worksheet Functions | |||
Concatenate and keep preceeding zeros | Excel Worksheet Functions | |||
save text field w/ leading zeros in .csv format & not lose zeros? | Excel Discussion (Misc queries) |