software

Is there a way to have Excel automatically change the cell value from
being a function the just being the value of the function? For example

From:
cell value= 1 2 ISPLAY: 3

To:
cell value= 3 ISPLAY: 3

Or someway to store that data in another cell would be nice too. I know
that you can copy the value of a function to another cell, but I want it
to automatically do this that way I can write a program that will
prepare itself for the next month overnight without any employees
having to format the data, and rewrite it.

~Greg--
gregory.barrett
------------------------------------------------------------------------
gregory.barrett's Profile: www.excelforum.com/member.php...oamp;userid=32421
View this thread: www.excelforum.com/showthread...hreadid=527763Hi Greg,

You can do this without a macro by copying the cells in a selection (Ctrl C)
then without changing the selection Edit, Paste Special, values.

You could do the same with a macro. See ReEnterAsValues in
www.mvps.org/dmcritchie/excel/join.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
Search Page: www.mvps.org/dmcritchie/excel/search.htm

quot;gregory.barrettquot; lt;gregory.barrett.25g4jz_1143660601.6203@excelfor um-nospam.comgt; wrote in message
news:gregory.barrett.25g4jz_1143660601.6203@excelf orum-nospam.com...
gt;
gt; Is there a way to have Excel automatically change the cell value from
gt; being a function the just being the value of the function? For example
gt;
gt; From:
gt; cell value= 1 2 ISPLAY: 3
gt;
gt; To:
gt; cell value= 3 ISPLAY: 3
gt;
gt; Or someway to store that data in another cell would be nice too. I know
gt; that you can copy the value of a function to another cell, but I want it
gt; to automatically do this that way I can write a program that will
gt; prepare itself for the next month overnight without any employees
gt; having to format the data, and rewrite it.
gt;
gt; ~Greg
gt;
gt;
gt; --
gt; gregory.barrett
gt; ------------------------------------------------------------------------
gt; gregory.barrett's Profile: www.excelforum.com/member.php...oamp;userid=32421
gt; View this thread: www.excelforum.com/showthread...hreadid=527763
gt;

I'm not to sure you understand what I'm trying to say. Although the 1st
link you gave me does help a bit. I don't want to do any of this
manually, it needs to be fully automatic.--
gregory.barrett
------------------------------------------------------------------------
gregory.barrett's Profile: www.excelforum.com/member.php...oamp;userid=32421
View this thread: www.excelforum.com/showthread...hreadid=527763You have to write the code manually first to automate it, there is nothing
built in that will do this. If you look at the link there are instructions
for VBA there--

Regards,

Peo Sjoblom

nwexcelsolutions.com
quot;gregory.barrettquot;
lt;gregory.barrett.25i3dy_1143752400.9062@excelfor um-nospam.comgt; wrote in
message news:gregory.barrett.25i3dy_1143752400.9062@excelf orum-nospam.com...
gt;
gt; I'm not to sure you understand what I'm trying to say. Although the 1st
gt; link you gave me does help a bit. I don't want to do any of this
gt; manually, it needs to be fully automatic.
gt;
gt;
gt; --
gt; gregory.barrett
gt; ------------------------------------------------------------------------
gt; gregory.barrett's Profile:
gt; www.excelforum.com/member.php...oamp;userid=32421
gt; View this thread: www.excelforum.com/showthread...hreadid=527763
gt;