Re: Number convert in to text ?




If you want to do this with a formula you can download the MOREFUNC
addin and use the NBTEXT function, then you just need

=NBTEXT(A1)

MOREFUNC addin is free, look here

http://www.rhdatasolutions.com/morefunc/

otherwise you need to use VBA


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=30486
View this thread: http://www.excelforum.com/showthread.php?threadid=503754

.



Relevant Pages

  • RE: How do I round to the nearest $250
    ... > You can use the MROUND() function within the morefunc addin to do this: ... > Use this link to download the add-in. ... >> I'm working on life insurance policy calculations and the policies are 4 time ...
    (microsoft.public.excel.worksheet.functions)
  • Re: for figure in Excel
    ... You could download Laurent Longre's MoreFunc addin which is freely ... The addin includes the NBTEXT function which converts a positive number into ... > This post is a suggestion for Microsoft, ...
    (microsoft.public.excel.programming)
  • Re: How to convert Number into words in EXCEL same or a new cell ?
    ... You could download Laurent Longre's MoreFunc addin which is freely ... The addin includes the NBTEXT function which converts a positive number into ... > cell command in same cell or by copy - paste special type into a new cell ...
    (microsoft.public.excel.worksheet.functions)
  • Re: "translate" numbers into words
    ... You could download Laurent Longre's MoreFunc addin which is freely ... The addin includes the NBTEXT function which converts a positive number into ... 'How to convert a numeric value into English words in Excel' ...
    (microsoft.public.excel.misc)
  • RE: WHEN ENTER NUMBER , DISPLAY IN WARDS ?
    ... You could download Laurent Longre's MoreFunc addin which is freely ... The addin includes the NBTEXT function which converts a positive number into ... In the latter cases, if you are not familiar with macros, you may wish to ...
    (microsoft.public.excel.worksheet.functions)