Forum home » Delegate support and help forum » Microsoft Excel Training and help » Maintain format of currency and or date whent cocantenating data
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Maintain format of currency and or date whent cocantenating data
Resolved · Low Priority · Version 2003
Reply Mon 18 Jul 2011, 17:06Delegate John said...
John has attended:
Presentation Skills course
Excel Advanced course
Maintain format of currency and or date whent cocantenating data
maintain format of currency and or date whent cocantenating data within a text string (for "lazy" report writing)
For upcoming training course dates see: Pricing & availability
RE: maintain format of currency and or date whent cocantenating
Hello John,
As I thought, Concatenate can only handle text but you can "translate" your currency and date data by using the Text function which combines a reference to the cell which contains the data with a currency / date picture (such as we use in Custom formatting) enclosed in " " to make it text.
Please see attached the test file I have put together for you.
C4 contains the main Concatenate function, the currency formatted data is in A6 with its Text function (referred to in the main formula) in C6. The formatted dates are in A8 and A10 with their Text functions in C8 and C10 respectively.
I leave it to your own judgement to decide if this solution still constitutes "lazy" report writing!
Kind regards,
Ruth
Attached files...
Concatenation Formatting Test.xlsReply Thu 21 Jul 2011, 12:56Delegate John said...
RE: maintain format of currency and or date whent cocantenating
Many thanks Ruth
many years of "lazy" report writing ahead for me (if I can find the customers)!
all the best
John F
|