Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 17
Default NUMERICALS CAN CHANGE IN ALPHABHATS

Dear Sir,

YOur help required for change of numericals in Alphabhats

such as 10300.00
Ten Thousand Three Hundred Only.

Such as1003000.00
One Million Three Thousand Only.


Thanks in advance

Regards
ZEESHAN ANIS
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,501
Default NUMERICALS CAN CHANGE IN ALPHABHATS

have a look here


http://www.ozgrid.com/VBA/ValueToWords.htm

Mike

"ZEESHAN ANIS" wrote:

Dear Sir,

YOur help required for change of numericals in Alphabhats

such as 10300.00
Ten Thousand Three Hundred Only.

Such as1003000.00
One Million Three Thousand Only.


Thanks in advance

Regards
ZEESHAN ANIS

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 17
Default NUMERICALS CAN CHANGE IN ALPHABHATS

Sir,

Thanks you very much,

Its too long and I cant understand it.

how can i copy these commands in VB while I can use VB through EXCEL but
this time . Your help required again.

Regards
ZEESHAN ANIS

"Mike H" wrote:

have a look here


http://www.ozgrid.com/VBA/ValueToWords.htm

Mike

"ZEESHAN ANIS" wrote:

Dear Sir,

YOur help required for change of numericals in Alphabhats

such as 10300.00
Ten Thousand Three Hundred Only.

Such as1003000.00
One Million Three Thousand Only.


Thanks in advance

Regards
ZEESHAN ANIS

Reply
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
Change numericals in alphabets. ZEESHAN ANIS[_2_] Excel Programming 2 April 10th 07 03:29 PM
Excel bar chart formatting of bars to change colors as data change JudyT Excel Discussion (Misc queries) 1 January 24th 07 06:07 PM
Use date modified to change format & create filter to track change PAR Excel Worksheet Functions 0 November 15th 06 09:17 PM
Change conditional formatting to coloured alternate rows dependent on a change in date? StargateFan[_3_] Excel Programming 4 August 2nd 06 11:28 AM
Change Cell from Validated List Not Firing Worksheet Change Event [email protected] Excel Programming 3 October 4th 04 03:00 AM


All times are GMT +1. The time now is 07:26 PM.

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

About Us

"It's about Microsoft Excel"