| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding Text, Date and Numbers together in a formula
Hi
Basically i have a list that comprises of the following information Date Amount 22/10/2008 (in date format) 2556.43835616438 (in number format,specific) All i want to be able to do is at the end of each row put the following into the cell "Paid 22/10/2008 £2,556.44" without having to write it out everytime. How can i have the word "Paid" with the date in cell A2 and the amount in cell B2 correct to 2dp. Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding numbers based on date | Excel Worksheet Functions | |||
| Adding numbers to text! | Excel Worksheet Functions | |||
| adding cells which include numbers and text | Excel Discussion (Misc queries) | |||
| adding cells with text and numbers | Excel Discussion (Misc queries) | |||
| Adding cells with numbers and text | Excel Worksheet Functions | |||
Threaded Mode
