MID Formula command

G

Guest

What do you get? The formula itself like =mid(etc)?
If so the cell is probably formatted as text, format as general and if
necessary
edit the cell with F2 and the press enter


Regards,

Peo Sjoblom
 
G

Guest

Hi
A bit more of a clue might help! What is your formula? What result are you
expecting? What result are you getting?
 
H

HGE

Thanks, I had formatted it as "general", but it took your second suggestion
to make it work.
 
G

Guest

If you have a lot of these, one way that usually works is to do an edit>replace
and replace = with = (replace equal sign with equal sign) that usually
triggers
what's needed and it is much faster than pressing F2 and enter in all cells
separately


Peo
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top