Split cost 16.95 in cells?????

[garvey2003]

Hi!

Below is an example I need to be able to do.

If I enter in say A1 "16.95" I need it split in to Thousands, Hundreds,
Tens, Units and in Word format.

I will be importing the data.

[image: http://garveynetworks.co.uk/images/example.jpg]

 

[Juan Sanchez]

I'm sure there is a better way, meanwhile...

=CHOOSE(INT(MOD(A10,10000)/1000)
+1,"ZERO","ONE","TWO","THREE","FOUR","FIVE","SIX","SEVEN","
EIGHT","NINE") & "," &CHOOSE(INT(MOD(A10,1000)/100)
+1,"ZERO","ONE","TWO","THREE","FOUR","FIVE","SIX","SEVEN","
EIGHT","NINE") & "," &CHOOSE(INT(MOD(A10,100)/10)
+1,"ZERO","ONE","TWO","THREE","FOUR","FIVE","SIX","SEVEN","
EIGHT","NINE") & "," &CHOOSE(INT(MOD(A10,10)/1)
+1,"ZERO","ONE","TWO","THREE","FOUR","FIVE","SIX","SEVEN","
EIGHT","NINE")

Here's a formula that works...

Cheers
Juan

 

[Max]

Juan, .. guess your test cells were in row10, not row1? <g>
(clue was from the cell ref "A10")

--
Rgds
Max
xl 97
---
Please respond in thread
xdemechanik <at>yahoo<dot>com
----

I'm sure there is a better way, meanwhile...

=CHOOSE(INT(MOD(A10,10000)/1000)
+1,"ZERO","ONE","TWO","THREE","FOUR","FIVE","SIX","SEVEN","
EIGHT","NINE") & "," &CHOOSE(INT(MOD(A10,1000)/100)
+1,"ZERO","ONE","TWO","THREE","FOUR","FIVE","SIX","SEVEN","
EIGHT","NINE") & "," &CHOOSE(INT(MOD(A10,100)/10)
+1,"ZERO","ONE","TWO","THREE","FOUR","FIVE","SIX","SEVEN","
EIGHT","NINE") & "," &CHOOSE(INT(MOD(A10,10)/1)
+1,"ZERO","ONE","TWO","THREE","FOUR","FIVE","SIX","SEVEN","
EIGHT","NINE")

Here's a formula that works...

Cheers
Juan

-----Original Message-----
Hi!

Below is an example I need to be able to do.

If I enter in say A1 "16.95" I need it split in to Thousands, Hundreds,
Tens, Units and in Word format.

I will be importing the data.

[image: http://garveynetworks.co.uk/images/example.jpg]

 

[Juan Sanchez]

Yes, indeed... I bet he can fix that, if he wants to use
that long crappy formula... if he can't..., well, what can
I say

Cheers
Juan

-----Original Message-----
Juan, .. guess your test cells were in row10, not row1?

(clue was from the cell ref "A10")

--
Rgds
Max
xl 97
---
Please respond in thread
xdemechanik <at>yahoo<dot>com
----

I'm sure there is a better way, meanwhile...

=CHOOSE(INT(MOD(A10,10000)/1000)
+1,"ZERO","ONE","TWO","THREE","FOUR","FIVE","SIX","SEVEN","
EIGHT","NINE") & "," &CHOOSE(INT(MOD(A10,1000)/100)
+1,"ZERO","ONE","TWO","THREE","FOUR","FIVE","SIX","SEVEN","
EIGHT","NINE") & "," &CHOOSE(INT(MOD(A10,100)/10)
+1,"ZERO","ONE","TWO","THREE","FOUR","FIVE","SIX","SEVEN","
EIGHT","NINE") & "," &CHOOSE(INT(MOD(A10,10)/1)
+1,"ZERO","ONE","TWO","THREE","FOUR","FIVE","SIX","SEVEN","
EIGHT","NINE")

Here's a formula that works...

Cheers
Juan

-----Original Message-----
Hi!

Below is an example I need to be able to do.

If I enter in say A1 "16.95" I need it split in to Thousands, Hundreds,
Tens, Units and in Word format.

I will be importing the data.

[image: http://garveynetworks.co.uk/images/example.jpg]

.

 

[Max]

that long crappy formula...
... definitely not, imho .. it works fine
cheers, Juan