Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
sir in excel how we convert number to te
 
Posts: n/a
Default Convert from number to text

sir in excel how we convert number to text in english version???
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CLR
 
Posts: n/a
Default Convert from number to text

Assuming that you are wishing to enter numbers to display with leading zeros,
you can just type an apostrophe before typing the number, or by
pre-formatting the cell for TEXT........Right-click FormatCells NumberTab
TEXT..........


Vaya con Dios,
Chuck, CABGx3



"sir in excel how we convert number to te" wrote:

sir in excel how we convert number to text in english version???

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bpeltzer
 
Posts: n/a
Default Convert from number to text

If you want to write out a numeric value in words, see
http://support.microsoft.com/default...b;en-us;213360 (result of
searching for 'spell number' at microsoft.com)

"sir in excel how we convert number to te" wrote:

sir in excel how we convert number to text in english version???

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
how can I convert numeric number into text firas Excel Discussion (Misc queries) 1 September 21st 05 07:05 PM
Formulas dealing with text data Bagia Excel Worksheet Functions 6 June 20th 05 10:29 PM
How to COnvert text string to number timtak Excel Discussion (Misc queries) 3 June 4th 05 04:57 AM
How do I convert a number formated as a date to text in Excel? BrotherNov Excel Discussion (Misc queries) 5 March 2nd 05 03:51 PM
Convert Numeric into Text Monty Excel Worksheet Functions 0 December 18th 04 09:25 PM


All times are GMT +1. The time now is 04:00 AM.

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"