Split cost 16.95 in cells?????

  • Thread starter Thread starter garvey2003
  • Start date Start date
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
 
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
----
Juan Sanchez said:
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]
Click to expand...
Click to expand...
 
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?
Click to expand...
(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]
Click to expand...
Click to expand...


.
Click to expand...
 
Back
Top