Vcoderz Community
We create websites that have it all, beauty & brains
Lebanon Web Design & Development - Coddict
 

Go Back   Vcoderz Community > Computer Zone > Computers & Information Technologies

Notices

Computers & Information Technologies Everything related to computers and internet.

Reply
 
Share Thread Tools Search this Thread
Old 02-22-2011   #1
chady28
Registered Member
 
chady28's Avatar
 
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
Default 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


chady28 is offline   Reply With Quote
Old 02-22-2011   #2
Google

 
Google's Avatar
 
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
Default

=CONCATENATE( B1, "" )

Where B1 is a number.
__________________

Google is offline   Reply With Quote
Old 02-22-2011   #3
chady28
Registered Member
 
chady28's Avatar
 
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
Default

Quote:
Originally Posted by Google View Post
=CONCATENATE( B1, "" )

Where B1 is a number.
didn't work it just copied the same number in the cell
chady28 is offline   Reply With Quote
Old 02-22-2011   #4
-t-o-n-y-
Registered Member
 
-t-o-n-y-'s Avatar
 
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
Default

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
-t-o-n-y- is offline   Reply With Quote
The Following User Says Thank You to -t-o-n-y- For This Useful Post:
chady28 (02-23-2011)
Old 02-26-2011   #5
7anzala
Registered Member
 
7anzala's Avatar
 
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
Default

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...
7anzala is offline   Reply With Quote
Reply

  Vcoderz Community > Computer Zone > Computers & Information Technologies

Tags
excel



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

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT +1. The time now is 07:22 AM.


Lebanon web design and development
Powered by vBulletin® Version 3.8.3
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Ad Management plugin by RedTyger
Share