Numbers To Text - Easier Way ?

[CONFUSED_AS_USUAL]

Hi,

Probably an embarrassing question. But, how can I change a range of numbers in numbers format to text format with 1 button or a macro ? It does not work by just changing the format. The only cumbersome way that I have found is to insert another adjacent column and use the "text" function. Then format it to values and delete a row.

Too cumbersome & I do this too often. Must be an easier way.

Thks.

 

[MrKowz]

Might I ask why you want to convert numbers to text (string)? Generally I see requests about going the other way.

To directly address your question though, is it a specific column that you do this to each time? It wouldn't be too difficult to build some code to accomplish this.

 

[SyedUsman]

Select column then goto data > text to columns > next > next > text > finish

 

[Fluff]

How about text to columns.
On Data tab select text to columns, Next,Next, then select Text & finish

 

[CONFUSED_AS_USUAL]

This is good. I will be able to create a macro with this.

Thank you Syed.

 

[Rick Rothstein]

But, how can I change a range of numbers in numbers format to text format with 1 button or a macro ? It does not work by just changing the format.

Why doesn't it work by just changing the format? If you do the Text To Columns method, which you seem to indicate works for you, it does the same thing as formatting the cells would do (as far as I can see). What is it about changing the format that you think does not work for you?

 

[shg]

Changing the format doesn't change an already-entered number to text, Rick.

[Table="width:, class:grid"][tr][td="bgcolor:#C0C0C0"][/td][td="bgcolor:#C0C0C0"]

A​

[/td][td="bgcolor:#C0C0C0"]

B​

[/td][td="bgcolor:#C0C0C0"]

C​

[/td][td="bgcolor:#C0C0C0"]

D​

[/td][/tr][tr][td="bgcolor:#C0C0C0"]

1​

[/td][td]

123​

[/td][td="bgcolor:#E5E5E5"]

TRUE​

[/td][td]B1: =ISNUMBER(A1)[/td][td]Format of A1: General[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

2​

[/td][td]

123​

[/td][td="bgcolor:#E5E5E5"]

TRUE​

[/td][td]B2: =ISNUMBER(A2)[/td][td]Format of A2: @[/td][/tr]
[/table]

 

[Rick Rothstein]

Changing the format doesn't change an already-entered number to text, Rick.

[Table="width:, class:grid"][tr][td="bgcolor:#C0C0C0"][/td][td="bgcolor:#C0C0C0"]

A​

[/td][td="bgcolor:#C0C0C0"]

B​

[/td][td="bgcolor:#C0C0C0"]

C​

[/td][td="bgcolor:#C0C0C0"]

D​

[/td][/tr][tr][td="bgcolor:#C0C0C0"]

1​

[/td][td]

123​

[/td][td="bgcolor:#E5E5E5"]

TRUE​

[/td][td]B1: =ISNUMBER(A1)[/td][td]Format of A1: General[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

2​

[/td][td]

123​

[/td][td="bgcolor:#E5E5E5"]

TRUE​

[/td][td]B2: =ISNUMBER(A2)[/td][td]Format of A2: @[/td][/tr]
[/table]

Yes, of course (I was thinking the OP wanted something else when I posted that).

 

[CONFUSED_AS_USUAL]

Might I ask why you want to convert numbers to text (string)? Generally I see requests about going the other way.

To directly address your question though, is it a specific column that you do this to each time? It wouldn't be too difficult to build some code to accomplish this.

Hi Mr.Kowz,

Yes, I must admit that it is unusual. However, this is how are system is set up.

To answer your question - no, the column will not always be the same. Maybe code that would only be affected only if it recognizes it as being that is highlighted - meaning chosen as if ready to be copied ?

 

[MrKowz]

Hi Mr.Kowz,

Yes, I must admit that it is unusual. However, this is how are system is set up.

To answer your question - no, the column will not always be the same. Maybe code that would only be affected only if it recognizes it as being that is highlighted - meaning chosen as if ready to be copied ?

Understandable. The other people who have posted here have pretty well the best solution (text-to-columns). You should be able to utilize the macro recorder to get the general code for what you're trying to accomplish. If you need any assistance amending the code to fit your scenario, let us know!