Converting number to text with formatting in VBA

You need to double up the internal double quotes eg

Range("l1:l4000").FormulaR1C1 = _
"=text(RC[-4],""[h]:mm"")"

Hope this helps
Rowan

[email protected] wrote:
> ok, her is what I have
> E F
> 14:00 15:00
>
> I want the out put to look the same only converted to text in the l
> column. I can do it with formulas in each cell, but when I try to get
> VBA to drop the formulas in the cells, it errors. I am using:
>
> Range("l1:l4000").FormulaR1C1 = _
> "=text(RC[-4],"[h]:mm")"
>
> Range("m1:m4000").FormulaR1C1=_
> "=text(RC[-4],"[h]:mm")"
>
> basically it is seeing the " and taking that as the end.
>
> Any ideas?
>

ok, her is what I have
E F
14:00 15:00

I want the out put to look the same only converted to text in the l
column. I can do it with formulas in each cell, but when I try to get
VBA to drop the formulas in the cells, it errors. I am using:

Range("l1:l4000").FormulaR1C1 = _
"=text(RC[-4],"[h]:mm")"

Range("m1:m4000").FormulaR1C1=_
"=text(RC[-4],"[h]:mm")"

basically it is seeing the " and taking that as the end.

Any ideas?

your a geniuse thanks

You're welcome.

[email protected] wrote:
> your a geniuse thanks
>