»
 

Go Back   ResellerRatings Store Ratings > ResellerRatings Forums > Tech Support
Excel Spreadsheet Help Excel Spreadsheet Help
Register FAQ Social Groups Calendar Search Today's Posts Mark Forums Read

Reply
 
LinkBack Thread Tools Display Modes
Old 04-09-2004, 10:51 AM   #1 (permalink)
Registered User
 
Join Date: Mar 2003
Posts: 103
Marvinator is on a distinguished road
Excel Spreadsheet Help
I have a user with a large Excel spreadsheet. He's been working on this for some time. NOw, today he opens the sheet, and tells me that within all the cells, he sees only FORMULAS instead of the VALUES That the formula is looking to produce.

I know that this is a simple toggle, but for the life of me, I can't find it.

My undying respect to the expert with the answer to this headscratcher!

THANKS!!

__________________
<img src=http://delta-laydee.com/marvs/marv.gif>
Marvinator is offline   Reply With Quote
Old 04-09-2004, 11:00 AM   #2 (permalink)
Registered User
 
jmichna's Avatar
 
Join Date: Oct 2001
Location: Chicagoland IL
Posts: 1,539
jmichna is on a distinguished road
On Excel's Menu bar, go to Tools... Options... View tab, and deselect checkbox "Formulas" under "Windows options."
__________________
A man becomes rich not by having what he wants, but by wanting what he haves.
jmichna is offline   Reply With Quote
Old 04-09-2004, 11:03 AM   #3 (permalink)
Registered User
 
Join Date: Mar 2003
Posts: 103
Marvinator is on a distinguished road
Thanks!
__________________
<img src=http://delta-laydee.com/marvs/marv.gif>
Marvinator is offline   Reply With Quote
Old 04-09-2004, 11:05 AM   #4 (permalink)
Registered User
 
jmichna's Avatar
 
Join Date: Oct 2001
Location: Chicagoland IL
Posts: 1,539
jmichna is on a distinguished road
Quote:
Originally posted by Marvinator
Thanks!
My pleasure... post back if this didn't do it.
__________________
A man becomes rich not by having what he wants, but by wanting what he haves.
jmichna is offline   Reply With Quote
Reply

« plz help, im lost! | Got my package from Uncle Bill »


« plz help, im lost! | Got my package from Uncle Bill »

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Most Active Discussions

Recent Discussions

All times are GMT -6. The time now is 08:09 PM.

Contact Us - ResellerRatings - Archive - Privacy Statement - Top