Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default save Excel calc' as the number

How do I get rid of the formula and just keep the answer? I'm sure I've
done it before!
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 427
Default save Excel calc' as the number

Copy, then Paste Special and chose Value

Steve



On Wed, 14 Feb 2007 10:18:25 -0000, Rich01260
wrote:

How do I get rid of the formula and just keep the answer? I'm sure I've
done it before!

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default save Excel calc' as the number

Easy! Thanks
R

"SteveW" wrote:

Copy, then Paste Special and chose Value

Steve



On Wed, 14 Feb 2007 10:18:25 -0000, Rich01260
wrote:

How do I get rid of the formula and just keep the answer? I'm sure I've
done it before!


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
My calc key on Excel changes box to "Text" Box and doesn't calc ? jack Charts and Charting in Excel 0 August 8th 06 07:30 PM
some excel fomulas don't update, even if I hit F9, auto calc = on BJG2005 Excel Discussion (Misc queries) 2 July 17th 06 05:51 PM
auto calc on, but have to edit (f2) cells to force re-calc..help! Curt Excel Worksheet Functions 3 February 13th 06 06:05 PM
count number of values between plus signs in addition calc CRH Excel Discussion (Misc queries) 5 December 2nd 05 11:56 PM
Excel Won't Calc? Eric Excel Worksheet Functions 7 October 26th 05 02:19 PM


All times are GMT +1. The time now is 08:16 PM.

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

About Us

"It's about Microsoft Excel"