Merging cells must be text format

  • Thread starter Programmer wanna be
  • 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.
 
P

Programmer wanna be

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
 
F

Frank Kabel

Hi
this format is just for adding 'thousand-delimiters'. So It should work
regardless of the value in cell A2
 
Top