Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Reggie
 
Posts: n/a
Default Embedding a reference in a cell with normal text.

Hello,

I would like to enter the following data in a cell:

Standard Deviation (B17)

The B17 reference is the contents of cell B17, which I
would like to have automatically entered without having to
retype it 5 gazilion times.

Thank you very much!

Reg
  #2   Report Post  
Max
 
Posts: n/a
Default

One guess ..

Try in say, C17: ="Standard Deviation "&TEXT(B17,"0.000")

(assuming it's to be formatted to 3 dp)

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Reggie" wrote in message
...
Hello,

I would like to enter the following data in a cell:

Standard Deviation (B17)

The B17 reference is the contents of cell B17, which I
would like to have automatically entered without having to
retype it 5 gazilion times.

Thank you very much!

Reg



  #3   Report Post  
Max
 
Posts: n/a
Default

Just a small refinement to bring it closer to what was posted ..
Try instead: ="Standard Deviation ("&TEXT(B17,"0.000")&")"
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----


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
Maintaining cell reference after sorting GRITS Excel Discussion (Misc queries) 2 April 30th 23 07:42 PM
Autofitting a row Josephine Excel Discussion (Misc queries) 2 March 3rd 05 03:37 PM
How do I print all the text in a cell Dorna Tucker Excel Discussion (Misc queries) 4 February 3rd 05 04:23 PM
Formula with text and reference to a date cell [email protected] Excel Discussion (Misc queries) 1 January 11th 05 08:15 AM
Formatting a cell as "text" in the number catagory. Ed Excel Worksheet Functions 3 December 7th 04 07:12 PM


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