| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How to specify numeric format in formula?
I have a cell with the following:
="The value is $" & A6 & "." Cell A6 is an integer and it's formatting is set to look like "4,000.00". In the cell above that references A6 the value looks like "4000". How can I explicitly specify formatting in my "=" statement above? Thanks! |
|
#2
|
|||
|
|||
|
="The value is " & TEXT(A1,"#,##0.00") & "."
|
|
#3
|
|||
|
|||
|
Forgot: add the $ sign like this:
="The value is " & TEXT(A1,"$#,##0.00") & "." |
|
#4
|
|||
|
|||
|
Use text
="The value is "&TEXT(A6,"$#,##0.00")&"." Regards, Peo Sjoblom wrote in message oups.com... I have a cell with the following: ="The value is $" & A6 & "." Cell A6 is an integer and it's formatting is set to look like "4,000.00". In the cell above that references A6 the value looks like "4000". How can I explicitly specify formatting in my "=" statement above? Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| number format problem when using =A1&A2 formula | Excel Discussion (Misc queries) | |||
| Conditonal Format Formula | Excel Worksheet Functions | |||
| Display Format with Text & Formula | Excel Worksheet Functions | |||
| Make Change Case in Excel a format rather than formula | Excel Worksheet Functions | |||
| How do I format a character from a result of formula in excel? | Excel Discussion (Misc queries) | |||
Linear Mode
