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. |
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 |