Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

copy values that have been computed by formulas 1

Status
Not open for further replies.
mimi2

mimi2

Technical User
Apr 2, 2002
407
CA
Hello,
I have an excel file that contains percentages.
I need to make a chart with these values. When i try to copy the data in another sheet, i get zeros...

is there a way to copy absolute values ?
thanks a lot.
 
Sort by date Sort by votes
Edit>Paste Special>Values

Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

remeng
  • Locked
  • Question
Power Query Split by Table Group by Rows into a new set of group by tables
Replies
2
Views
460
remeng
remeng
OCM
  • Locked
  • Question
lookup values
Replies
2
Views
474
OCM
OCM
PSchubert
  • Locked
  • Question
Excel: Formula only works with certain numerical values
Replies
12
Views
1K
dhookom
dhookom
D
  • Locked
  • Question
How can i have more than 1 line in the body of an email
Replies
2
Views
461
Andrzejek
Andrzejek
remeng
  • Locked
  • Question
Excel Pivot Table - Combine Values into a single row
Replies
16
Views
2K
remeng
remeng

Part and Inventory Search

Sponsor

Back
Top