Vcoderz Community - Excel help

Vcoderz Community (http://forum.vcoderz.com/index.php)

- Computers & Information Technologies (http://forum.vcoderz.com/forumdisplay.php?f=6)

- - Excel help (http://forum.vcoderz.com/showthread.php?t=19779)

chady28

02-22-2011 10:39 AM

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

Google

02-22-2011 11:36 AM

=CONCATENATE( B1, "" )

Where B1 is a number.

chady28

02-22-2011 12:11 PM

Quote:

Originally Posted by Google (Post 228548)

=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 03:05 PM

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 04:26 PM

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

All times are GMT +1. The time now is 08:53 AM.