how do i separate cell value in four different cells?

  • Thread starter Thread starter sit
  • Start date Start date
S

sit

Thanks for the tip but i think i should explain some more. If th
amount is 250.50 (USD) it should be displayed in the last 5 cell
excluding the dot(assuming that amount is no more than five digits an
50 cents).
This shoud be a simple accounting operation to transfer a single cel
ammount in to assignet cells to the right.
If you have ideas... help pleas
 
try these
=MID(TEXT(A1,"0.00"),1,1) =MID(TEXT(A1,"0.00"),2,1)
=MID(TEXT(A1,"0.00"),3,1)


5,1
6,1
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how do i separate cell value in four different cells? 2
how do i separate cell value in four different cells? 1
How to write the SUM of two MAX numbers in four or more than four cells 1
how do I separate different points within a cell in Excel 1
how do i separate 2 strings of a cell in different cells? 1
How do I separate and calculate a value in a cell with an IF 2
How do I stop worksheets from duplicating cell in a different wor. 2
SD03*10 -how do I just get the numbers at the end in cell after * 3

Back
Top