ExcelBanter - Convert number to text as displayed

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Convert number to text as displayed (https://www.excelbanter.com/excel-worksheet-functions/447368-convert-number-text-displayed.html)

[email protected]

Convert number to text as displayed

I have some data that appears in cells as: $37,920.00, $719.45, $2,850,500.00.

plinius

Convert number to text as displayed

Il 13/10/2012 01:18, ha scritto:
I have some data that appears in cells as: $37,920.00, $719.45, $2,850,500.00.
In the Formula Bar these numbers look like: 37920, 719.45, 2850500. The cells are formatted as Currency. What I would like is to capture the characters that make up the cell appearance. I know that this would change the numbers to text which is also desireable. The goal is to merge them into a Word mailing form. Is there a way to change these numbers into text with dollar sign, commas, and zeros in decimal places without retyping them?

=TEXT(A1,"$ 0,0.00")

E.

[email protected]

Convert number to text as displayed

On Saturday, October 13, 2012 2:50:52 AM UTC-7, plinius wrote:
Il 13/10/2012 01:18, ha scritto:

I have some data that appears in cells as: $37,920.00, $719.45, $2,850,500.00.

In the Formula Bar these numbers look like: 37920, 719.45, 2850500. The cells are formatted as Currency. What I would like is to capture the characters that make up the cell appearance. I know that this would change the numbers to text which is also desireable. The goal is to merge them into a Word mailing form. Is there a way to change these numbers into text with dollar sign, commas, and zeros in decimal places without retyping them?

=TEXT(A1,"$ 0,0.00")

oward
E.

After seeing this solution, I believe I misunderstood the OP request.

Howard

Ron Rosenfeld[_2_]

Convert number to text as displayed

On Fri, 12 Oct 2012 16:18:06 -0700 (PDT), wrote:

I have some data that appears in cells as: $37,920.00, $719.45, $2,850,500.00.
In the Formula Bar these numbers look like: 37920, 719.45, 2850500. The cells are formatted as Currency. What I would like is to capture the characters that make up the cell appearance. I know that this would change the numbers to text which is also desireable. The goal is to merge them into a Word mailing form. Is there a way to change these numbers into text with dollar sign, commas, and zeros in decimal places without retyping them?

Another option to consider would be to format the Merge Field in Word. That might give you more control with less hassle.
e.g: MERGEFIELD "Amt \\* DollarText" \* Caps is an example of a field that I use in a merged document that is based on a numeric amount in my Excel worksheet.

All times are GMT +1. The time now is 05:04 AM.