Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Using formatted cells in formulas
I have been provided a worksheet with a list of 5-digit part numbers that
the creator of the worksheet formatted as zip code to preserve leading zeros. I need to use these cells in a formula which uses the "&" operator to tack on a suffix. For example: Original part number cell A1 = 2345 (with zip code formatting displays as 02345) I need cell A2 to be 02345XX, so I'm using the following formula: A1&"XX". Problem is, when I do this, Excel drops the leading zero and displays 2345XX. Is there a way to have Excel use the formatted display string for cell A1 instead of the underlying numeric value? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
refreshing formulas in cells | Excel Discussion (Misc queries) | |||
Copy range of cells omitting formulas that result in " " | Excel Discussion (Misc queries) | |||
loan calculator cells, P&I formulas do not copy to second cloumn | Excel Worksheet Functions | |||
Copy & Paste Visible Cells with Formulas | Excel Worksheet Functions | |||
how to copy formulas to other cells in excell | Setting up and Configuration of Excel |