ExcelBanter - Format amount in string

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Format amount in string (https://www.excelbanter.com/excel-discussion-misc-queries/114259-format-amount-string.html)

[email protected]

Format amount in string

In cell A1 I have the value 10271,623 formatted as a number so it is
displayed as 10.272

In cell A2 I want to display some text and the formatted amount in cell
A1, something like:

="My text: "& A1

If I do it as above it is displayed as "My text: 10271,623" instead of
"My text: 10.272". How can I change that?

Regards,

S

Dave O

Format amount in string

I got this one to work:
="mytext "&TEXT(A1,"0.000,,")

Kevin B

Format amount in string

In cell A2 type the following:

="My Text: "&TEXT(ROUND(A1/1000000,3),"##.###")
--
Kevin Backmann

" wrote:

In cell A1 I have the value 10271,623 formatted as a number so it is
displayed as 10.272

In cell A2 I want to display some text and the formatted amount in cell
A1, something like:

="My text: "& A1

If I do it as above it is displayed as "My text: 10271,623" instead of
"My text: 10.272". How can I change that?

Regards,

S

All times are GMT +1. The time now is 02:42 AM.