LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
BrianW
 
Posts: n/a
Default Why doen't PasteSpecial, Formulas not display formula in cell?

I want to paste the formul's from a cell into another cell. Other
spreadsheet programs allow this for a single cell. I'm aware of paste
special , select formula button but the value is displayed. I can make this
work by copying the text in a fourmul and preceeding the past in another cell
with a ', but this is very cumbersom when I have to do it hundreds of times
in a column, and the result is not associative with the source.
 
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
Cell display is 38727.4101273148 Formula Bar is 1/10/2006 9:50 Dennis Excel Discussion (Misc queries) 3 January 10th 06 04:11 PM
copy and pasting a find all list into another column Ben Excel Discussion (Misc queries) 18 December 31st 05 10:51 PM
Possible Lookup Table Karen Excel Worksheet Functions 5 June 8th 05 09:43 PM
inserting data from a row to a cell, when the row number is specified by a formula in a cell [email protected] New Users to Excel 2 January 6th 05 07:18 AM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 07:16 PM


All times are GMT +1. The time now is 09:30 AM.

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"