Text for Values

[Ampleford]

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....

 

[SIXTH SENSE]

Hi!
use nbtext() function from morefunc addin

 

[Ampleford]

will functions from "morefunc" work on other machines (which don't have "morefunc") ?

 

[SIXTH SENSE]

hi!
No.
They have to have that add in too!
Or make your own UDF which will b shipted witht the workbook itself.

 

[Ampleford]

how do I do that ?

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

 

[PaddyD]

" or would I just be best using the lookup"

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

 

[Ampleford]

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

ray:

 

[PaddyD]

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)

 

[Ampleford]

as always - thanks guys....... (and gals)

 

[Ahampson9658]

simple way :

Tools - AutoCorrect - Replace
type"1"

With
type "one"

magic !!

hope that helps