ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   how can i convert digists in to characters in a spread sheet (https://www.excelbanter.com/excel-worksheet-functions/168522-how-can-i-convert-digists-characters-spread-sheet.html)

Raja Aurongzeb

how can i convert digists in to characters in a spread sheet
 
for example if i write 15,000 and i want to convert it in to characters as
Fiteen thousand only is there any function in excel spread sheet available to
convert digits into characters

Niek Otten

how can i convert digists in to characters in a spread sheet
 
Look he

http://xldynamic.com/source/xld.xlFAQ0004.html

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Raja Aurongzeb" <Raja wrote in message
...
| for example if i write 15,000 and i want to convert it in to characters as
| Fiteen thousand only is there any function in excel spread sheet available to
| convert digits into characters




All times are GMT +1. The time now is 01:00 AM.

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