Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]() i want to convert no. e.g. 100 to text as one hundred Ron Rosenfeld Wrote: On Sun, 21 Aug 2005 06:33:33 -0500, torpido wrote: I managed to work the MoreFunc with my own currency, but i couldnt set the "after point" like Cents. You should be able to. Post a sample of the raw number and how you want it displayed, and I should be able to give you the proper syntax. --ron -- crestendo ------------------------------------------------------------------------ crestendo's Profile: http://www.excelforum.com/member.php...o&userid=34259 View this thread: http://www.excelforum.com/showthread...hreadid=397468 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Convert numbers from text format to number format | Excel Discussion (Misc queries) | |||
edit number in cell without it changing to text | Excel Discussion (Misc queries) | |||
Format Number to Text | Excel Worksheet Functions | |||
16 digit number wont keep alteration unless format cell to text | Excel Discussion (Misc queries) | |||
EZ Q 4 U: How do I change a number to text, based on the number | Excel Worksheet Functions |