Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 116
Default convert number to text

Please, How Can I make Excel convert a given number in a cell to text

EXAMPLE : 2155.50 L.E to "Two thounsands one hundred and fifty five,50/100

POUNDS" .

أى ان يقوم إكسل بتفقيط مبلغ أو رقم موجود فى خلية ما
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,856
Default convert number to text

Please don't start a second thread on the same topic - you have an
answer elsewhere.

Pete

On Nov 8, 11:31*pm, SHERRY wrote:
Please, How Can I make Excel convert a given number in a cell to text

EXAMPLE : *2155.50 L.E *to "Two thounsands one hundred and fifty five,50/100

*POUNDS" .

أى ان يقوم إكسل بتفقيط مبلغ أو رقم موجود فى خلية ما


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
Convert text to number GrantW Excel Discussion (Misc queries) 2 October 26th 07 05:37 AM
Convert text number to number formate [email protected] Excel Discussion (Misc queries) 2 April 9th 07 10:48 AM
number convert to text MBPC Excel Worksheet Functions 2 November 29th 05 12:20 PM
convert text-format number to number in excel 2000%3f Larry Excel Discussion (Misc queries) 1 July 29th 05 08:18 PM
not able to convert text, or graphic number to regular number in e knutsenk Excel Worksheet Functions 1 April 2nd 05 08:41 AM


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