Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Binyaaust
 
Posts: n/a
Default display values of formulas in Excel

I am using Excel 2002 to link two workbooks. In destination, I got the
formulas instead of values for all columns pointing to constants (text
format), and values for other columns pointing to cells containing numbers.
All of them are linked to the same workbook in the exactly same way. And I
have tried Ctrl+`, but it only widen the columns for me (I do not know why).

Could any guru please help for this?
  #2   Report Post  
Bernie Deitrick
 
Posts: n/a
Default

Binyaaust,

Do not format the cells for text, even if you are expecting the formulas to
return text. Format the cells for General, and re-enter the formulas. Text
formatting forces anything entered into the cell to be text - which is why
you see your formula. Applying the General format after entering the formula
into a cell formatted as Text won't do anything - you need to re-format and
re-enter.

HTH,
Bernie
MS Excel MVP


"Binyaaust" wrote in message
...
I am using Excel 2002 to link two workbooks. In destination, I got the
formulas instead of values for all columns pointing to constants (text
format), and values for other columns pointing to cells containing

numbers.
All of them are linked to the same workbook in the exactly same way. And I
have tried Ctrl+`, but it only widen the columns for me (I do not know

why).

Could any guru please help for this?



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 do I summarize totals for a list of values in Excel? KelleyS Excel Worksheet Functions 2 April 13th 05 09:56 PM
I want Excel to allow cells with formulas and unrelated text blueboy Excel Discussion (Misc queries) 9 March 4th 05 01:22 AM
How do I display records using a key field in Excel? Vic from Texas Excel Worksheet Functions 1 March 1st 05 11:16 PM
How do I get to master Excel functions and formulas? Basabjit Chowdhury Excel Worksheet Functions 3 December 29th 04 09:15 PM
delete values in several cells without deleting the formulas dranreb Excel Discussion (Misc queries) 4 December 9th 04 02:15 AM


All times are GMT +1. The time now is 04:04 PM.

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

About Us

"It's about Microsoft Excel"