Formula to Add $ and/or commas
 

Hi,
I have a column of amounts
5000
75
750
10000

and would like them to be
$5,000
$75
$750
$10,000

I can't use format cells, because I actually want to add the $ and commas,
not just change their format for a merge into word.

Any help would be greatly appreciated!
Bryce

Formula to Add $ and/or commas
 

You can use another column and enter this formula:

=DOLLAR(A1,0)

Drag down as needed.

Note that this converts the numeric values to *TEXT* values so you need to
take that into account if you want to do any downstream calculations.

--
Biff
Microsoft Excel MVP


"Outlook, eh?" wrote in message
...
Hi,
I have a column of amounts
5000
75
750
10000

and would like them to be
$5,000
$75
$750
$10,000

I can't use format cells, because I actually want to add the $ and commas,
not just change their format for a merge into word.

Any help would be greatly appreciated!
Bryce

Formula to Add $ and/or commas
 

=text(a1,"$#,##0")

and copy down

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Outlook, eh?" wrote in message
...
Hi,
I have a column of amounts
5000
75
750
10000

and would like them to be
$5,000
$75
$750
$10,000

I can't use format cells, because I actually want to add the $ and commas,
not just change their format for a merge into word.

Any help would be greatly appreciated!
Bryce

Formula to Add $ and/or commas
 

If you're using them as a merge, simply format the merge field in Word
appropriately. That way you don't need to change your source numbers
into text.

See the "Format merged data" topic in Word help.



In article ,
Outlook, eh? wrote:

Hi,
I have a column of amounts
5000
75
750
10000

and would like them to be
$5,000
$75
$750
$10,000

I can't use format cells, because I actually want to add the $ and commas,
not just change their format for a merge into word.

Any help would be greatly appreciated!
Bryce

Formula to Add $ and/or commas
 

=TEXT(A2,"$#,##0.00")

then copy and paste as values, note that it will be text


--
Regards,

Peo Sjoblom




"Outlook, eh?" wrote in message
...
Hi,
I have a column of amounts
5000
75
750
10000

and would like them to be
$5,000
$75
$750
$10,000

I can't use format cells, because I actually want to add the $ and commas,
not just change their format for a merge into word.

Any help would be greatly appreciated!
Bryce

Formula to Add $ and/or commas
 

Thanks so much everyone! =Dollar(A1,0) worked like a charm!

"Peo Sjoblom" wrote:

=TEXT(A2,"$#,##0.00")

then copy and paste as values, note that it will be text


--
Regards,

Peo Sjoblom




"Outlook, eh?" wrote in message
...
Hi,
I have a column of amounts
5000
75
750
10000

and would like them to be
$5,000
$75
$750
$10,000

I can't use format cells, because I actually want to add the $ and commas,
not just change their format for a merge into word.

Any help would be greatly appreciated!
Bryce