Excel likes to help.

Try this on a test worksheet.
Select A1 and hit ctrl-; (to put the date in the cell)
now select B1 and type: =a1

Notice that excel changed the format of B1 to match the format in A1.

Now format D1 as Text.
put ASDF in D1
put =D1 in E1
You see ASDF.

With E1 selected, hit the F2 key and then enter (to pretend that you're changing
the formula).

Excel has "helped" you by changing that cell's format to text.

I don't know of any way of changing this behavior.

I just select the cell, and reformat it to General (or whatever I wanted). I
hit F2 and then enter (to reenter that formula).

Sometimes this feature is nice, sometimes it ain't.

=======
You may want to post what your macro does. Maybe it would be as simple as
formatting the cell as General, then applying the formula.




kineski wrote:

Have tried this but the next time the macro runs it goes back to the old format

"Gord Dibben" wrote:

Try re-entering the formula by hitting F2ENTER

If you have many, select all cells and EditReplace

what: =

with: =

Replace All and Ok

Hit CTRL + ` to toggle show formulas off?


Gord Dibben MS Excel MVP

On Thu, 20 Apr 2006 16:53:02 -0700, kineski
wrote:

I have changed cell from text to General but it keeps going back to text
automatically



--

Dave Peterson