Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
sir in excel how we convert number to text in english version???
|
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how can I convert numeric number into text | Excel Discussion (Misc queries) | |||
Formulas dealing with text data | Excel Worksheet Functions | |||
How to COnvert text string to number | Excel Discussion (Misc queries) | |||
How do I convert a number formated as a date to text in Excel? | Excel Discussion (Misc queries) | |||
Convert Numeric into Text | Excel Worksheet Functions |