View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.setup
MTC MTC is offline
external usenet poster
 
Posts: 5
Default 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.