LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 28
Default How do I type text and have a formula in the same cell?

Not quite sure what you are trying to do. If you simply want to display the
formula as text (without the formula being active) then simply preceed it
with an apostrophe. Its not possible to have text and a formula result in the
same cell unless you first convert the formula result into text and then
concatenate it with the main text.

"Mads Beier" wrote:

Is it in any way posible? Either with 'text'=formula or in any wy like that?

 
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



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

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"