Because you said that you got the same value and because you said that one
of the things you wanted was:
"When I drag the formula down from cell D2 it change with the vlaue in A, B
and C column."
--
David Biddulph


"tipoo" wrote in message
...
Hi Stefi,

Amazing....! Your r spot on I did turn the auto cal off but how did u know
that I turned auto cal off?

"Stefi" wrote:

In addition you should check your Calculations setting
(ToolsOptionsCalculations tab), because your example suggests that it's
set
to Manual. Set it to automatic!
Regards,
Stefi


"tipoo" ezt írta:

Hi Guys,

I'm using =concatenate(A2,".",B2,".",C2) in Column D. But when I drag
it
down from cell D2 down I get same values.

Column A Column B Column C Column D Vlaues in
Column D
sould be
15007 5709 15007.5709.
15007.5709
18090 5015 300 15007.5709.
18090.5015.300

I want:
1 - When Column C is blank then do not use decimal at the end of the
numbers
in column D;

2 - When I drag the formula down from cell D2 it change with the vlaue
in A,
B and C column.

Will appreciate your feedback.

Thanks