98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Maintain format of currency and or date whent cocantenating data
Maintain format of currency and or date whent cocantenating data
Resolved · Low Priority · Version 2003
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)
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...
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. |
Excel tip:Create own ribbon tab - Excel 2010a. In Excel click on the File tab |