how do i separate cell value in four different cells?

S

sit

I've changed the formula you gave me =MID(TEXT(A1,"0.00"),1,1) int
this: =MID(TEXT(A1,"0000000000.00"),1,1) so all the numbers to b
displayed from right to left. It is just fine, if i wrote 1523.25 i ge
this 0 | 0 | 0 | 0 | 0 | 0 | 1 | 5 | 2 | 3 | 2 | 5 but i need to remov
all those unusable 0 | 0 | 0 | 0's it works with "conditiona
formating" ( if cell value is equal to 0 -> font color=white) but i
the number is 1503.25 i get this | 1 | 5 | | 3 | .2 | 5 .
Any bright ideas
 
D

Don Guillett

It your numbers are in col A, put this in col B and copy ACROSS as far as
desired. Then copy B2:x2 or whatever your column is DOWN. Now try different
numbers in col a.

=MID(TEXT($A1,"0.0"),COLUMN(A1),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

separating single cell value numbers in different cells 1
Excel Need Countifs Formula Help 0
how do i separate cell value in four different cells? 2
different values shown when #DIV/0! error is returned as result 3
Scrabble Value calculation for Welsh words 0
Calculate the value of Z 12
Add to current cell value 1
SOS! how do I do multiple-value lookup in Excel 2007? 1

Top