View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Programmer wanna be Programmer  wanna be is offline
external usenet poster
 
Posts: 5
Default Merging cells must be text format

I have two cells I need to merge: The first:

CELL A1: CREDIT LIMIT
CELL A2: 10000000

The end result needs to look like this:

CREDIT LIMIT $ 10,000,000

Please help.