Convert numbers to text

[Aland2929]

I have a column of a few thousand numbers I need to convert to text. Can I code the following steps: [F2], [Home], ', [Enter] or is there an easier way to do this?
Thanks in advance

[Mordred]

What do you mean by

Can I code the following steps: [F2], [Home], ', [Enter]

[Fotis1991]

Hi

Take a look here.

http://www.ozgrid.com/VBA/ValueToWords.htm

[Aland2929]

1. Press the Edit key
2. Press the Home key
3. Insert a label prefix
4. Press Enter

I would need to do this for a few thousand rows.

[smuzoen]

You could use the formula =TEXT(A1,"0") where the second parameter is format - e.g. 1 decimal place =TEXT(A1,"0.0") - copy down the formula. Are they in a continuous range i.e. One column, multiple columns - if using a formula and copying the formula is no good then

Please Login or Register  to view this content.

Assuming the values are in Column A only otherwise would need to offset to past last column of data
Hope this helps
Anthony

[Mordred]

I don't see what that has to do with converting numbers to text. Sorry, I guess this is a multipart question? Usually, 2 different problems means 2 different threads so that their topics are findable by others.

[smuzoen]

Why do you need to convert numbers to text

[Aland2929]

Thanks Smuzoen. It worked perfectly.

[smuzoen]

Excellent - make sure you change the thread to SOLVED

.
Anthony
“Confidence never comes from having all the answers; it comes from being open to all the questions.”
PS: Remember to mark your questions as Solved once you are satisfied and rate the answer(s) questions.”