Thread: Excel 2003 I want text quoted and then the value of a cell followi
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JE McGimpsey JE McGimpsey is offline
external usenet poster
  
Posts: 4,624
Default Excel 2003 I want text quoted and then the value of a cell followi
One way:

="1D8+" & B1

BTW: "didn't work" isn't very informative.


You can also use cell formatting. In the cell, put

=B1

and choose Format/Cells/Number/Custom "1D8+"General

In article ,
tenchi wrote:

In Excel 2003 SP2 I need the text '1D8+' followed by the value of a different
cell. I tried Cell Formating but it didn't work.
Reply With QuoteReply With Quote