Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 16th 08, 06:08 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2006
Posts: 87
Default Turning forumula results as absolute numbers

I have about 290 text boxes (list) on the left side of the worksheet numbered
sequestionally. Just like a list. I have tabulated data across the page
(left to right) using a formula to sum the columns across the page for each
of the 290 items. What I would like to do is to eliminate the columns now
but retain the totals for each of the 290 items in order to use as a table
for my dissertation.

Is it possible to "turn-off" the formulas so that when I delete the columns
(between list and totals), my totals don't go away? I would hate to retype
each of the numbers total for each item - not to mention how tedious that is
but also chance for more human error. Any help is appreciated.

Thanks!

  #2   Report Post  
Old January 16th 08, 06:14 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 1,047
Default Turning forumula results as absolute numbers

hi,

why not to copy and paste special values, before delete the data?

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Edward" escreveu:

I have about 290 text boxes (list) on the left side of the worksheet numbered
sequestionally. Just like a list. I have tabulated data across the page
(left to right) using a formula to sum the columns across the page for each
of the 290 items. What I would like to do is to eliminate the columns now
but retain the totals for each of the 290 items in order to use as a table
for my dissertation.

Is it possible to "turn-off" the formulas so that when I delete the columns
(between list and totals), my totals don't go away? I would hate to retype
each of the numbers total for each item - not to mention how tedious that is
but also chance for more human error. Any help is appreciated.

Thanks!

  #3   Report Post  
Old January 16th 08, 06:16 PM posted to microsoft.public.excel.misc
CLR CLR is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 1,998
Default Turning forumula results as absolute numbers

How about just highlighting the offending columns and doing right-click Hide

Vaya con Dios,
Chuck, CABGx3



"Edward" wrote:

I have about 290 text boxes (list) on the left side of the worksheet numbered
sequestionally. Just like a list. I have tabulated data across the page
(left to right) using a formula to sum the columns across the page for each
of the 290 items. What I would like to do is to eliminate the columns now
but retain the totals for each of the 290 items in order to use as a table
for my dissertation.

Is it possible to "turn-off" the formulas so that when I delete the columns
(between list and totals), my totals don't go away? I would hate to retype
each of the numbers total for each item - not to mention how tedious that is
but also chance for more human error. Any help is appreciated.

Thanks!

  #4   Report Post  
Old January 16th 08, 07:22 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2006
Posts: 87
Default Turning forumula results as absolute numbers

Thanks! :-)

"Marcelo" wrote:

hi,

why not to copy and paste special values, before delete the data?

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Edward" escreveu:

I have about 290 text boxes (list) on the left side of the worksheet numbered
sequestionally. Just like a list. I have tabulated data across the page
(left to right) using a formula to sum the columns across the page for each
of the 290 items. What I would like to do is to eliminate the columns now
but retain the totals for each of the 290 items in order to use as a table
for my dissertation.

Is it possible to "turn-off" the formulas so that when I delete the columns
(between list and totals), my totals don't go away? I would hate to retype
each of the numbers total for each item - not to mention how tedious that is
but also chance for more human error. Any help is appreciated.

Thanks!

  #5   Report Post  
Old January 16th 08, 07:22 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2006
Posts: 87
Default Turning forumula results as absolute numbers

Gracias Amigo! :-)

"CLR" wrote:

How about just highlighting the offending columns and doing right-click Hide

Vaya con Dios,
Chuck, CABGx3



"Edward" wrote:

I have about 290 text boxes (list) on the left side of the worksheet numbered
sequestionally. Just like a list. I have tabulated data across the page
(left to right) using a formula to sum the columns across the page for each
of the 290 items. What I would like to do is to eliminate the columns now
but retain the totals for each of the 290 items in order to use as a table
for my dissertation.

Is it possible to "turn-off" the formulas so that when I delete the columns
(between list and totals), my totals don't go away? I would hate to retype
each of the numbers total for each item - not to mention how tedious that is
but also chance for more human error. Any help is appreciated.

Thanks!



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
how to stop numbers turning to hash ? Oliver Swadkin Excel Discussion (Misc queries) 3 October 29th 07 10:45 PM
Can I change a column of calculated numbers to absolute numbers? Kate Bissell Excel Discussion (Misc queries) 3 October 25th 06 06:10 PM
Turning positive numbers to negative rajivvyas Excel Discussion (Misc queries) 3 March 28th 06 05:24 PM
Numbers turning to Zero's DaveG Excel Discussion (Misc queries) 1 March 4th 06 12:57 PM
turning numbers into other numbers Dino Thomas Excel Worksheet Functions 1 March 5th 05 07:51 PM


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

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017