ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to convert numbers to text format? (https://www.excelbanter.com/excel-discussion-misc-queries/166323-how-convert-numbers-text-format.html)

Kishore

How to convert numbers to text format?
 
if i have

1 in cell a1, i need that to be changed into One in cell B1, how is this done?

regards

kishore

Frederik[_3_]

How to convert numbers to text format?
 
Have a look at:

http://exceltips.vitalnews.com/Pages...elled_Out.html

Success!!

"kishore" schreef in bericht
...
if i have

1 in cell a1, i need that to be changed into One in cell B1, how is this
done?

regards

kishore




Gary''s Student

How to convert numbers to text format?
 

See:

XL2000: How to Convert a Numeric Value into English Words
http://support.microsoft.com/default...N-US;Q213360&;


--
Gary''s Student - gsnu200756


"kishore" wrote:

if i have

1 in cell a1, i need that to be changed into One in cell B1, how is this done?

regards

kishore



All times are GMT +1. The time now is 02:41 PM.

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