| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combining text and cell reference keeping number format
Dear All,
I have a spreadsheet with a value of 123.889977 in cell A5 I have formatted it to currency and 0 decimal places so it looks like £124. This figure is derived from a sum. In cell C3 I have ="Total shortfall is "&A5 but it looks like this... Total shortfall is 123.889977 - How would I edit the formula to keep the formatting so that it reads Total shortfall is £124 ? Many thanks Rajen |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to copy a number into a text cell, keeping leading zeros? | Charts and Charting in Excel | |||
| combining cells and keeping decimal format | Excel Discussion (Misc queries) | |||
| Making cell reference absolute makes cell format text | Excel Worksheet Functions | |||
| Time format to number while keeping value | Excel Worksheet Functions | |||
| Combining cell reference with text | Excel Discussion (Misc queries) | |||
Threaded Mode
