Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need some comments on my Utility_Move class module. | Excel Worksheet Functions | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
Deferring conditional formatting? | Excel Discussion (Misc queries) | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
Function syntax to compare cell contents | Excel Worksheet Functions |