Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting Cells
Hi,
I have a w/sheet where Column A contains a 4 digit number and Column B An 8 Alphanumeric figure. e.g. below: A B 0130 MADA2582 0450 MADA2582 1041 MADA2582 2030 MADA2582 The format cells for Column A is set to Custom 0000 so that the 0 is visible. I want to enter in column C the formula: =A2&" "&B2 So the figure i want looks like: 0130 MADA2582 BUT, when i do this it changed the figure to: 130MADA2582 How would i go about changing this? so that i can get the figure 0130 MADA2582??? As i need the figure to run a lookup and when i run the look up on 130 MADA2582, it does not pick up the 0130 MADA2582 codes. Your help would be greatly appreciated Ryan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deferring conditional formatting? | Excel Discussion (Misc queries) | |||
checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
Conditional formatting...cont. from 9/25 | Excel Discussion (Misc queries) | |||
Excel should allow more options for formatting cells | Excel Worksheet Functions | |||
How to copy "edge" formatting to other cells. | Excel Discussion (Misc queries) |