Merging cells must be text format

  • Thread starter Thread starter Programmer wanna be
  • Start date Start date
P

Programmer wanna be

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.
 
Thank for your help.

Unfortunately the credit limit values change depending on account the
formula is assigned to. Is there a way to automatically, through a
formula determine the amount of characters, then assign the commas
accordingly?

thanks
 
Hi
this format is just for adding 'thousand-delimiters'. So It should work
regardless of the value in cell A2
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA set thick borders around non empty cells in range 0
Excel 2013 Merge Data 2
concatenate two cells, but with conditions 2
wrap text in merge cells 7
Strip out certain rows that have merged cells 2
Merging cells and copy! 3
Merge the contents of multiple cells into one cell 3
Copy/Transpose into a matrix of merged cells. Use Offset formula orVBA ? 2

Back
Top