Thread: how do I format numbers as text
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default how do I format numbers as text
Those are not numbers.

100 A-B in one cell is already text.

What do you mean by your subject line?


Gord Dibben MS Excel MVP

On Mon, 18 Jan 2010 17:18:01 -0800, Brenda
wrote:

for example
100 A-B
7 C-D
56 A-b
65 A-b

Reply With QuoteReply With Quote