Display results of formulas

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Helder - 07 Nov 2006 17:03 GMT

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

Reply to this Message

Bob Phillips - 07 Nov 2006 17:06 GMT

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

Signature

HTH

Bob Phillips

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

> Hi
> I have a worksheet with a big database and with some useforms in VBA...I
[quoted text clipped - 3 lines]
> automatic...
> Somebody help me....this begins freeking me out

Reply to this Message

Allllen - 07 Nov 2006 17:10 GMT

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

Signature

Allllen

> Hi
> I have a worksheet with a big database and with some useforms in VBA...I
[quoted text clipped - 3 lines]
> automatic...
> Somebody help me....this begins freeking me out

Reply to this Message