Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
Shifting the contents of cells
Hi
I am a maths teacher and I want to be able to show how the decimal system works. For example, take the number 123, I want each digit to be in its own cell and then when I multiply be ten I want the contents of each cell to shift left and add a zero., 123o, again with each digit in its own cell. I know I will haved to write some code but I need some help to get going so that I can read and write to a cell from a macro or something Many thanks for any suggestions. |
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
Shifting the contents of cells
Hi MTC,
There is no need for any code! Fill in cells like below: A1: 123 your example number B1: create a validation list with values 1,10,100,1000 C1: insert formula =A1*B1 D1: insert formula =IF(ISERROR(MID($C1,LEN($C1)-(9-COLUMN()),1)),"",MID($C1,LEN($C1)-(9-COLUMN()),1)) drag this formula to right until cell I1 Regards, Stefi €˛MTC€¯ ezt Ć*rta: Hi I am a maths teacher and I want to be able to show how the decimal system works. For example, take the number 123, I want each digit to be in its own cell and then when I multiply be ten I want the contents of each cell to shift left and add a zero., 123o, again with each digit in its own cell. I know I will haved to write some code but I need some help to get going so that I can read and write to a cell from a macro or something Many thanks for any suggestions. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking Groups of cells between workbooks | Excel Discussion (Misc queries) | |||
Deleting cells and shifting "right" | Excel Discussion (Misc queries) | |||
Insert contents of various cells in a column into one cell? | Excel Discussion (Misc queries) | |||
Clear Contents - NonBold cells | Excel Discussion (Misc queries) | |||
stop excel from shifting cells up when a query returns no data | Excel Worksheet Functions |