ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Convert from number to text (https://www.excelbanter.com/excel-worksheet-functions/78033-convert-number-text.html)

sir in excel how we convert number to te

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

CLR

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???


bpeltzer

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???



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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com