« previous next »
Pages: [1]

Author Topic: MS Excel Help  (Read 662 times)

Ex-MA Hole

  • friend
  • Senior Member
  • ***
  • Posts: 3,976
    • The Brown Bomber
MS Excel Help
« on: June 25, 2007, 09:47:59 AM »
I have created a spreadsheed entering my costs (in column B) for a particular project
I created a second column that has a formula adding to and totalling up my cost + markup % = sell (column C).

I need to send this to the client.

Is there a way, other then re-typesetting all the numbers in column C, to make column C appear as entered numbers, not showing my formula (which has my cost and markup in it)?

Thanks.

M
Report to moderator   Logged
One day at a time.

Brad Johnson

  • friend
  • Senior Member
  • ***
  • Posts: 18,143
  • Witty, charming, handsome, and completely insane.
Re: MS Excel Help
« Reply #1 on: June 25, 2007, 09:57:06 AM »
Does he need it in excel format?  If not, it might be easier to do a simple cut and past of that column into Word.

If it has to be excel I'd do a cut and paste special (contents only) into a seperate sheet.

Brad
Report to moderator   Logged
It's all about the pancakes, people.
"And he thought cops wouldn't chase... a STOLEN DONUT TRUCK???? That would be like Willie Nelson ignoring a pickup full of weed."
-HankB

Ex-MA Hole

  • friend
  • Senior Member
  • ***
  • Posts: 3,976
    • The Brown Bomber
Re: MS Excel Help
« Reply #2 on: June 25, 2007, 10:00:40 AM »
Thanks!

Word it is!!!
Report to moderator   Logged
One day at a time.

Brad Johnson

  • friend
  • Senior Member
  • ***
  • Posts: 18,143
  • Witty, charming, handsome, and completely insane.
Re: MS Excel Help
« Reply #3 on: June 25, 2007, 10:18:06 AM »
You may have to use the Paste Special function in Word, too, or it will paste in the formula and not the result.

Edit - Past Special

Brad
Report to moderator   Logged
It's all about the pancakes, people.
"And he thought cops wouldn't chase... a STOLEN DONUT TRUCK???? That would be like Willie Nelson ignoring a pickup full of weed."
-HankB

Ex-MA Hole

  • friend
  • Senior Member
  • ***
  • Posts: 3,976
    • The Brown Bomber
Re: MS Excel Help
« Reply #4 on: June 25, 2007, 10:34:52 AM »
Actually, I was able to cut from Excel, and Paste (regular paste), and it showed the number only, not the formula?

Not sure why, but it worked.

Thanks!
Report to moderator   Logged
One day at a time.

K Frame

  • friend
  • Senior Member
  • ***
  • Posts: 44,761
  • I Am Inimical
Re: MS Excel Help
« Reply #5 on: June 25, 2007, 11:12:47 AM »
You'd better be sure that your formula isn't in the background if you're actually trying to keep the recipient from seeing how you arrived at the numbers.
Report to moderator   Logged
Carbon Monoxide, sucking the life out of idiots, 'tards, and fools since man tamed fire.
Pages: [1]
« previous next »