use formatting from source cell in CONCATENATE function
I created a special format so that leading 0's in a value are printed.
However when using the CONCATENATE function of excel, the formatting is ignored and the leading 0's are dropped. It would be valuable (to me) if the formatting of a cell (number of decimal places, leading zeros, etc was "honored" by the CONCATENATE function. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions |
use formatting from source cell in CONCATENATE function
Let's say
A1 = 001 (custom format) B1 = cat Formula C1 =CONCATENATE(TEXT(A1,"000"),B1) The result will be 001cat "zacarab" wrote: I created a special format so that leading 0's in a value are printed. However when using the CONCATENATE function of excel, the formatting is ignored and the leading 0's are dropped. It would be valuable (to me) if the formatting of a cell (number of decimal places, leading zeros, etc was "honored" by the CONCATENATE function. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions |
use formatting from source cell in CONCATENATE function
Thank you (sorry to all about the duplicate post)
"Teethless mama" wrote: Let's say A1 = 001 (custom format) B1 = cat Formula C1 =CONCATENATE(TEXT(A1,"000"),B1) The result will be 001cat "zacarab" wrote: I created a special format so that leading 0's in a value are printed. However when using the CONCATENATE function of excel, the formatting is ignored and the leading 0's are dropped. It would be valuable (to me) if the formatting of a cell (number of decimal places, leading zeros, etc was "honored" by the CONCATENATE function. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions |
All times are GMT +1. The time now is 02:52 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com