#1   Report Post  
Old March 29th 06, 08:26 PM posted to microsoft.public.excel.misc
gregory.barrett
 
Posts: n/a
Default Data Storage


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: http://www.excelforum.com/member.php...o&userid=32421
View this thread: http://www.excelforum.com/showthread...hreadid=527763


  #2   Report Post  
Old March 30th 06, 02:13 AM posted to microsoft.public.excel.misc
David McRitchie
 
Posts: n/a
Default Data Storage

Hi 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
http://www.mvps.org/dmcritchie/excel/join.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"gregory.barrett" <[email protected] um-nospam.com wrote in message
news:[email protected] orum-nospam.com...

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: http://www.excelforum.com/member.php...o&userid=32421
View this thread: http://www.excelforum.com/showthread...hreadid=527763



  #3   Report Post  
Old March 30th 06, 09:55 PM posted to microsoft.public.excel.misc
gregory.barrett
 
Posts: n/a
Default Data Storage


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: http://www.excelforum.com/member.php...o&userid=32421
View this thread: http://www.excelforum.com/showthread...hreadid=527763

  #4   Report Post  
Old March 30th 06, 10:23 PM posted to microsoft.public.excel.misc
Peo Sjoblom
 
Posts: n/a
Default Data Storage

You 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

http://nwexcelsolutions.com



"gregory.barrett"
<[email protected] um-nospam.com wrote in
message news:[email protected] orum-nospam.com...

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:
http://www.excelforum.com/member.php...o&userid=32421
View this thread: http://www.excelforum.com/showthread...hreadid=527763





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
ranking query JaimeTimbrell Excel Discussion (Misc queries) 2 February 16th 06 08:09 AM
Importing Data Jillian Excel Worksheet Functions 9 December 23rd 05 12:45 PM
I need more general XY point to point plotting than XY scatter in spazminator Charts and Charting in Excel 12 December 19th 05 05:00 PM
newbie needs help with data storage mrclox Excel Discussion (Misc queries) 0 November 22nd 05 09:52 PM
Line Graph Data Recognition Nat Charts and Charting in Excel 2 April 30th 05 02:07 PM


All times are GMT +1. The time now is 09:53 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017