ExcelBanter - From 1001 to 1001-1

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - From 1001 to 1001-1 (https://www.excelbanter.com/excel-worksheet-functions/90006-1001-1001-1-a.html)

Steved

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.

Kim

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.

Steved

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.

All times are GMT +1. The time now is 08:17 AM.