Excel help

chady28 · 02-22-2011

Hey guys ,

anyone knows a way i can convert numbers to text in excel ???

and not the (BAhTEXT) formula cz it changes is to the Malaysian language

**Google** · 02-22-2011

=CONCATENATE( B1, "" )

Where B1 is a number.

chady28 · 02-22-2011

Quote:

Originally Posted by Google

=CONCATENATE( B1, "" )

Where B1 is a number.

didn't work it just copied the same number in the cell

-t-o-n-y- · 02-22-2011

check this site .... i tried it and worked but i dont know how to modify the code to remove the dollars and cents ...or read some articles in here i don't know if you would find anything else

7anzala · 02-26-2011

when u enter the number in the options there is text choice .... just choose it and the number is not considered as number again.ya3ne if u make a sum the cell is not calculated

02-22-2011	#1
chady28 Registered Member Last Online: 12-18-2013 Join Date: Jan 2007 Posts: 96 Thanks: 212 Thanked 8 Times in 5 Posts Groans: 0 Groaned at 1 Time in 1 Post	Excel help Hey guys , anyone knows a way i can convert numbers to text in excel ??? and not the (BAhTEXT) formula cz it changes is to the Malaysian language

02-22-2011	#2
Google Last Online: 05-30-2013 Join Date: Jan 2008 Posts: 1,788 Thanks: 10,018 Thanked 1,100 Times in 651 Posts Groans: 1 Groaned at 6 Times in 6 Posts	=CONCATENATE( B1, "" ) Where B1 is a number. __________________

02-26-2011	#5
7anzala Registered Member Last Online: 05-15-2012 Join Date: Sep 2006 Posts: 530 Thanks: 9 Thanked 41 Times in 34 Posts Groans: 0 Groaned at 1 Time in 1 Post	when u enter the number in the options there is text choice .... just choose it and the number is not considered as number again.ya3ne if u make a sum the cell is not calculated __________________ ALEXANDER Al-Kabeer Gonna rule you all...

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search

02-22-2011	#4
-t-o-n-y- Registered Member Last Online: 03-13-2012 Join Date: Nov 2006 Posts: 974 Thanks: 2,087 Thanked 482 Times in 317 Posts Groans: 15 Groaned at 3 Times in 3 Posts	check this site .... i tried it and worked but i dont know how to modify the code to remove the dollars and cents ...or read some articles in here i don't know if you would find anything else

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)