**Question description:**

*This user has given permission to use the problem statement for this blog.*

## I have a row of numbers in column B. I want to divide all those numbers by 2.2 in column C. Please help - I am 78 and have forgotten how to do it!

Solved by G. L. in 59 mins

**This is the chat thread from the real Excelchat help session. It contains no private user information.**

**Excelchat Expert**06/08/2018 - 03:07

Hello

**Excelchat Expert**06/08/2018 - 03:07

How are you today?

**Excelchat Expert**06/08/2018 - 03:10

Please respond so that I can assist.

**User**06/08/2018 - 03:15

I am fine, thanks. Sorry I could not get my computer to type in answers to above questions.

**Excelchat Expert**06/08/2018 - 03:15

No problem

**Excelchat Expert**06/08/2018 - 03:16

Can you see the preview on the right?

**Excelchat Expert**06/08/2018 - 03:18

This is the formula you have to use

**Excelchat Expert**06/08/2018 - 03:18

=B2/2.2

**Excelchat Expert**06/08/2018 - 03:19

where b2 is the cell

**Excelchat Expert**06/08/2018 - 03:19

then copy is down and this formula will copy

**Excelchat Expert**06/08/2018 - 03:19

Thank you and have ag reat day

**Excelchat Expert**06/08/2018 - 03:26

I am still here if you need some help

**Excelchat Expert**06/08/2018 - 03:41

I hope I have answered your query to your satisfaction.

**Excelchat Expert**06/08/2018 - 03:41

Please do provide good review after ending this session.

**User**06/08/2018 - 03:41

I tried your suggestion and it

**Excelchat Expert**06/08/2018 - 03:42

Ok

**Excelchat Expert**06/08/2018 - 03:42

is it working at your end?

**Excelchat Expert**06/08/2018 - 03:45

Please respond so that I can assist you.

**User**06/08/2018 - 03:46

I tried the formula on column E and it did not work

**Excelchat Expert**06/08/2018 - 03:47

Ok. Please tell me which cell you want to divide and show result on Column E

**Excelchat Expert**06/08/2018 - 03:48

Please check. I copied the formula from Cell C2 to E2

**Excelchat Expert**06/08/2018 - 03:48

In cell C2 formula is =B2/2.2

**Excelchat Expert**06/08/2018 - 03:48

When I copied it in E2 it becomes =D2/2.2

**Excelchat Expert**06/08/2018 - 03:49

Please check

**User**06/08/2018 - 03:49

I wanted to divide all numbers in column B by 2.2 to replicate what you did

**Excelchat Expert**06/08/2018 - 03:49

this formula is simple

**Excelchat Expert**06/08/2018 - 03:50

Please go to cell C2

**Excelchat Expert**06/08/2018 - 03:50

I deleted the formula

**Excelchat Expert**06/08/2018 - 03:50

now you enter the formula for the first division

**Excelchat Expert**06/08/2018 - 03:50

=B2/2.2

**Excelchat Expert**06/08/2018 - 03:51

Try this.

**Excelchat Expert**06/08/2018 - 03:52

Please go ahead and insert this formula and try if this is working.

**Excelchat Expert**06/08/2018 - 03:52

we just have 15 minutes left. We will not be able to extend the session any more.

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user information.*