| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
From 1001 to 1001-1
Hello from Steve Dee
Col A1 I have 1001 In Col B1 I would like to put a -1 so it looks like 1001-1 please. Secondly col C1 I have 23 in Col DI wolud like to put in front off it 10 to look like 1023 please. Thankyou for yor time. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
From 1001 to 1001-1
Hi Steve
Put the following formula into cell B1 =A1&"-1" Put the following formula into cell D1 ="10"&C1 Find more about this formula by reasearching "Concatenate" "Steved" wrote: Hello from Steve Dee Col A1 I have 1001 In Col B1 I would like to put a -1 so it looks like 1001-1 please. Secondly col C1 I have 23 in Col DI wolud like to put in front off it 10 to look like 1023 please. Thankyou for yor time. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
From 1001 to 1001-1
Thanks Kim
"Kim" wrote: Hi Steve Put the following formula into cell B1 =A1&"-1" Put the following formula into cell D1 ="10"&C1 Find more about this formula by reasearching "Concatenate" "Steved" wrote: Hello from Steve Dee Col A1 I have 1001 In Col B1 I would like to put a -1 so it looks like 1001-1 please. Secondly col C1 I have 23 in Col DI wolud like to put in front off it 10 to look like 1023 please. Thankyou for yor time. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you enter a ratio e.g. 100:1 into a cell? | Excel Worksheet Functions | |||
| Event 1001 & 1004 | Excel Discussion (Misc queries) | |||
Linear Mode
