| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
show text after formulas
I have some formulas with text added to the result. For example, I might
have a result of: 4.9¢/kWh In the formula cell, I set the numeric format to number, one digit after decimal. How do I retain the format when I have the numeric set to show commas? When I want to show a result of: 2,345,899 kWh Excel gives me a result of: 2345899 kWH. Why is it ignoring my format when I introduce text? A formula example when this happens might be: =ROUND(((G40/H45)*D19*100 ),0)&"kWh" help! this is driving me crazy!! I want to show units in the same cell, but these numbers need commas to read them easier!! Shirley |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel formulas to create large blocks of text | Excel Discussion (Misc queries) | |||
| Sort or Filter option? | Excel Worksheet Functions | |||
| Text to Columns - moves text up | Excel Discussion (Misc queries) | |||
| How do a convert a "text only (no formulas)" Excel (.xls) file to. | Excel Discussion (Misc queries) | |||
| Weekly Transaction Processing | Excel Worksheet Functions | |||
Threaded Mode
