LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Much help needed on conversion!


Hi there,

I'm currently working on a project .I will like to know if it is
possibe to actually convert text into certain numbers? An example will
be if user select ' system 1', upon clicking the macro button to update
sheet2 with the information, it will display '101' in sheet2. Meaning i
can define the text to convert into certain numerals.

like system 1 (in sheet 1) will become 200(set by me) in sheet 2 using
vba.

Thanks in advance!


--
oOpsy
------------------------------------------------------------------------
oOpsy's Profile: http://www.excelforum.com/member.php...o&userid=29132
View this thread: http://www.excelforum.com/showthread...hreadid=488525

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
csv conversion Rozman Excel Discussion (Misc queries) 2 January 5th 10 06:44 PM
Conversion barrowhill Excel Discussion (Misc queries) 7 January 19th 09 12:03 AM
Deleting Rows With Non-Needed Data between Needed Data Daren Excel Worksheet Functions 2 September 30th 08 06:47 PM
Date Conversion Formula Needed Titanium Excel Worksheet Functions 20 September 16th 07 09:18 PM
conversion needed juster21[_4_] Excel Programming 1 July 29th 05 09:44 PM


All times are GMT +1. The time now is 09:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"