| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
linking a text formatted cell to a formula cell
in cell A1 i have 00003128 custom formatted as text to 8 characters. in cell
B1, i have =A1&" Equity Sedol1". the problem is that the formula returns 3128 Equity Sedol1 when it needs to return 00003128 Equity Sedol1. text formatting is not helping. any ideas? thank! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
linking a text formatted cell to a formula cell
=Text(A1,"00000000")&" Equity Sedol1"
"lacy" wrote: in cell A1 i have 00003128 custom formatted as text to 8 characters. in cell B1, i have =A1&" Equity Sedol1". the problem is that the formula returns 3128 Equity Sedol1 when it needs to return 00003128 Equity Sedol1. text formatting is not helping. any ideas? thank! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| A lot of #'s in my text-formatted cell... | Excel Discussion (Misc queries) | |||
| Formula fails in text formatted cell | Excel Worksheet Functions | |||
| Formatted Cell Changes Format When Text Is Entered | Setting up and Configuration of Excel | |||
| Converting 'General' formatted cells to Text formatted cell using. | Excel Worksheet Functions | |||
| reference the result of a formula in a text formatted cell | Excel Discussion (Misc queries) | |||
Linear Mode
