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
|