Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
IRFAN AHMAD
 
Posts: n/a
Default converting amount into figures

Is there any wany to convert any amount into figure automatically.

100/-
should automatically convert into;;;;

one hundred only
  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default

See http://www.xldynamic.com/source/xld.xlFAQ0004.html

--

HTH

RP
(remove nothere from the email address if mailing direct)


"IRFAN AHMAD" wrote in message
...
Is there any wany to convert any amount into figure automatically.

100/-
should automatically convert into;;;;

one hundred only



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
Converting amount in figures to amount in words Shrikant Excel Discussion (Misc queries) 1 August 16th 05 10:42 AM
Formula to strip figures from cells text strings mikeburg Excel Discussion (Misc queries) 5 August 15th 05 10:31 PM
formula to calculate a benefit amount pgruening Excel Discussion (Misc queries) 6 August 9th 05 06:51 PM
Calculate minus figures only Nigel Excel Discussion (Misc queries) 0 March 30th 05 10:31 AM
Converting time figures into 24-hour format & sorting them... Clint Johnson Excel Worksheet Functions 1 February 23rd 05 01:23 AM


All times are GMT +1. The time now is 04:13 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"