Display results of formulas
 

Hi
I have a worksheet with a big database and with some useforms in VBA...I
entered another column to the data base and i was trying to do this formula:
"=mid(G2;16;11)"
The problem is that it doesn't calculate...and yes, calculation is
automatic...
Somebody help me....this begins freeking me out

Display results of formulas
 

What do you mean by doesn't calculate, MID always returns a string?



--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Helder" wrote in message
...
Hi
I have a worksheet with a big database and with some useforms in VBA...I
entered another column to the data base and i was trying to do this
formula:
"=mid(G2;16;11)"
The problem is that it doesn't calculate...and yes, calculation is
automatic...
Somebody help me....this begins freeking me out

Display results of formulas
 

what does it display? does it display
=mid(G2;16;11)

if it does, then the cell is formatted as text.
1) select the whole column and do format cells number general
2) now type in your formula again and press return
3) now extend it to the other cells in the column
--
Allllen


"Helder" wrote:

Hi
I have a worksheet with a big database and with some useforms in VBA...I
entered another column to the data base and i was trying to do this formula:
"=mid(G2;16;11)"
The problem is that it doesn't calculate...and yes, calculation is
automatic...
Somebody help me....this begins freeking me out