View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.newusers
LurfysMa LurfysMa is offline
external usenet poster
 
Posts: 61
Default How to imbed a cell reference in a text field?

On Thu, 14 Dec 2006 14:43:33 -0000, "Roger Govier"
wrote:

Hi

Another alternative, with a slight difference in layout would be to
Custom format the cell.
FormatCellsNumberCustom #0.00 "$ Cost / hour"

Then in the cell just enter
=E7


I thought about that and would have tried it eventually.

The possible advantage is the number value generated from the E7 value
is still a number and can be used in further calculation if required.


I don't understand. Why would I not just use E7 in any further
calculations?

--
Running Excel 2000 SP-3 on Windows 2000