Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
lady one
 
Posts: n/a
Default I PUT A FORMULA IN A CELL BUT I DON'T GET NUMBERS BUT THE FORMULA

when I put a numbers in the cell and click inter..I see the formula in the
appointed cell but not the number it self ..please help
  #2   Report Post  
Richard Buttrey
 
Posts: n/a
Default

On Sat, 24 Sep 2005 03:59:01 -0700, "lady one"
wrote:

when I put a numbers in the cell and click inter..I see the formula in the
appointed cell but not the number it self ..please help


It sounds like the cell is formatted as text.

Use Format Cells (number tab) and choose General.

Then Edit and Enter, and you should see the number.

HTH
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________
  #3   Report Post  
Aladin Akyurek
 
Posts: n/a
Default

1. Uncheck the Formulas option on the View tab under Tools|Options if
it's checked.

2. Format the cell as General, go the Formula Bar, and hit F2.

lady one wrote:
when I put a numbers in the cell and click inter..I see the formula in the
appointed cell but not the number it self ..please help

  #4   Report Post  
Bob Phillips
 
Posts: n/a
Default

Do you mean you see a formula, like =SUM(A1:A10)?

If so, go to ToolsOptionsView and uncheck the Formulas check box.

--
HTH

Bob Phillips

"lady one" wrote in message
...
when I put a numbers in the cell and click inter..I see the formula in the
appointed cell but not the number it self ..please help



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
Reference to One Cell stays the same in Different Formula ISMEGORDO Excel Discussion (Misc queries) 10 June 16th 05 11:13 PM
need help creating formula based on cell value Brad Excel Discussion (Misc queries) 3 April 1st 05 07:51 PM
Percent and Rank formula in one cell T.R. Excel Discussion (Misc queries) 1 March 10th 05 04:05 PM
Cell doesn't show formula result - it shows formula (CTRL + ' doe. o0o0o0o Excel Worksheet Functions 6 November 19th 04 03:13 PM
Conditional Formatting for dates spacerocket Excel Worksheet Functions 2 November 4th 04 10:13 AM


All times are GMT +1. The time now is 09:00 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"