| 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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Adding Text, Date and Numbers together in a formula
With date & value in A1 & B1, use:
="Paid " & TEXT(A1,"dd/mm/yyyy") & " £" & TEXT(B1,"#,##0.00") -- Gary''s Student - gsnu200808 "Bazy2k" wrote: 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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Adding Text, Date and Numbers together in a formula
Worked Beautifully! Thanks Gary.
"Gary''s Student" wrote: With date & value in A1 & B1, use: ="Paid " & TEXT(A1,"dd/mm/yyyy") & " £" & TEXT(B1,"#,##0.00") -- Gary''s Student - gsnu200808 "Bazy2k" wrote: 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. |
| Reply |
| 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 | |||
Linear Mode
