Go Back   Cyber Tech Help Support Forums > Software > Applications

Notices

Reply
 
Topic Tools
  #1  
Old June 19th, 2003, 08:40 PM
Dontech's Avatar
Dontech Dontech is offline
Member
 
Join Date: Jun 2003
Location: Wisconsin
Posts: 40
Excel-remove formula keep cell value

I'm working with excel and need to display the values in the cells, but I need to have the formula deleted. what command enables this cell format? I"m using Office 97 btw.

for example:

formula is : sum=4+2
Cell displays: 6

delete sum=4+2 but keep cell display of 6
Reply With Quote


  #2  
Old June 19th, 2003, 09:37 PM
Dontech's Avatar
Dontech Dontech is offline
Member
 
Join Date: Jun 2003
Location: Wisconsin
Posts: 40
Ok, figured this one out myself LOL

Select all cells
Edit- Copy - Paste Special - Select values -ok

Thanks anyways
Reply With Quote
  #3  
Old August 20th, 2010, 10:06 AM
Oliver Ticciati Oliver Ticciati is offline
New Member
 
Join Date: Aug 2010
Posts: 1
Brilliant!
Reply With Quote
  #4  
Old January 23rd, 2013, 10:05 PM
Data Dinosaur Data Dinosaur is offline
New Member
 
Join Date: Jan 2013
Posts: 1
Quote:
Originally Posted by Dontech View Post
Ok, figured this one out myself LOL

Select all cells
Edit- Copy - Paste Special - Select values -ok

Thanks anyways
I've never joined a forum before, but I was impressed with how your answer helped (ten years later!).
Reply With Quote
Reply

Bookmarks

Topic Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump




All times are GMT +1. The time now is 07:18 AM.