S
sit
512553.21 result 0 0 0 0 5 1 2 5 5 3 2 1
1512553.21 result 0 0 0 1 5 1
2 5 5 3 2 1
result of =MID(TEXT(A1,"0000000000.00"),1,1)
21254.32 result 2 1 2 5 4 3 2
1254.32 result 1 2 5 4 3 2
result of =MID(TEXT(A1,"0.00"),1,1)
The dost must not be shown.
The actual mean of this, is that i represent a single cell value in 1
different cells.
actualy this is an ammount 1254 Dollars and 32 Cents. The "cent" cell
must always be the last two cells (A11; A12) ignoring the dot. Th
"Dollar" cells must increment or decrement according to the ammount
The cells are 12 no more or less.
Thank you for your help
1512553.21 result 0 0 0 1 5 1
2 5 5 3 2 1
result of =MID(TEXT(A1,"0000000000.00"),1,1)
21254.32 result 2 1 2 5 4 3 2
1254.32 result 1 2 5 4 3 2
result of =MID(TEXT(A1,"0.00"),1,1)
The dost must not be shown.
The actual mean of this, is that i represent a single cell value in 1
different cells.
actualy this is an ammount 1254 Dollars and 32 Cents. The "cent" cell
must always be the last two cells (A11; A12) ignoring the dot. Th
"Dollar" cells must increment or decrement according to the ammount
The cells are 12 no more or less.
Thank you for your help