| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
& formula's
I write a commentary on excel which relates to figures in the same page. I
want to cut down on my time so I want to use "&" formula's to link into the cells e.g. 'sales are up "&cell&" on last year'. The formula's work but I can't convert that number into a % of £ sign or reduce the decimal places. Any ideas? |
|
#2
|
|||
|
|||
|
="Sales are up by "&TEXT(C5,"0.0%")
or ="Sales are up by "&TEXT(C5,"£#,##0.00") -- HTH RP (remove nothere from the email address if mailing direct) "Luke" wrote in message ... I write a commentary on excel which relates to figures in the same page. I want to cut down on my time so I want to use "&" formula's to link into the cells e.g. 'sales are up "&cell&" on last year'. The formula's work but I can't convert that number into a % of £ sign or reduce the decimal places. Any ideas? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problem with named formula's | Excel Worksheet Functions | |||
| Formulas | Excel Worksheet Functions | |||
| How to make Excel run limited number of formulas on a given worksh | Excel Discussion (Misc queries) | |||
| Way to make Excel only run certain formulas on a worksheet? | Excel Discussion (Misc queries) | |||
| calculating formulas for all workbooks in a folder | Excel Worksheet Functions | |||
Linear Mode
