Display results of formulas

[Guest]

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

 

[Bob Phillips]

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)

 

[Guest]

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