Text for Values

Ampleford

Active Member
Joined
Mar 26, 2002
Messages
380
Is it possible to change an integer to text. eg

"1" becomes "one"
"2" becomes "two"

etc etc

Its to concatenate some text ("we have three responses" instead of "we have 3 responses") - I'm doing it by lookup just now - but just wondered if there were an easier way....
 

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.

Ampleford

Active Member
Joined
Mar 26, 2002
Messages
380
will functions from "morefunc" work on other machines (which don't have "morefunc") ?
 

SIXTH SENSE

Well-known Member
Joined
Oct 29, 2003
Messages
1,883
hi!
No.
They have to have that add in too!
Or make your own UDF which will b shipted witht the workbook itself.
 

Ampleford

Active Member
Joined
Mar 26, 2002
Messages
380
how do I do that ?

(If you don't mind) - or would I just be best using the lookup...........
 

PaddyD

MrExcel MVP
Joined
May 1, 2002
Messages
14,234
" or would I just be best using the lookup"

how many possible 'conversions' are we talking about here?
 

Ampleford

Active Member
Joined
Mar 26, 2002
Messages
380
26 on this one, but i'm always thinking about a bigger case.........


to be honest - it's not really THAT important, so I don't want you guys wasting valuable time on it....


cheers

:pray:
 

PaddyD

MrExcel MVP
Joined
May 1, 2002
Messages
14,234
well, there's no short cut for getting the relationships out - you'll have to state them explicitly somewhere. so if you're not trying to do something like 123.1 = One hundred and twenty three point one, a lookup approach is probably as good as any. that said, here's a thread with a few examples of vba approaches:

http://www.mrexcel.com/board2/viewtopic.php?t=77943

(more could be found with a search for 'convert number text' or similar)
 

Forum statistics

Threads
1,186,166
Messages
5,956,335
Members
438,247
Latest member
UZev

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top