| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Format amount in string
I got this one to work:
="mytext "&TEXT(A1,"0.000,,") |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy with format | New Users to Excel | |||
| How do I convert numeric data to string format (without VBA)? | Excel Worksheet Functions | |||
| How to convert amount in word format (Like 40.00 is Rs. Forty ) | Excel Discussion (Misc queries) | |||
| Conditional Format Not Working | Excel Discussion (Misc queries) | |||
| Format monetary amount to 9 digits with No decimals without rounding | Excel Worksheet Functions | |||
Linear Mode
