ExcelBanter - value convert

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - value convert (https://www.excelbanter.com/excel-worksheet-functions/97174-value-convert.html)

hello

how to convert 1000000 convert to 1.000 or 1.000 Million

--
xman123
------------------------------------------------------------------------
xman123's Profile: http://www.excelforum.com/member.php...o&userid=35532
View this thread: http://www.excelforum.com/showthread...hreadid=557582

Custom format:

#.000,, "Million"

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"xman123" wrote in
message ...

hello

how to convert 1000000 convert to 1.000 or 1.000 Million

--
xman123
------------------------------------------------------------------------
xman123's Profile:
http://www.excelforum.com/member.php...o&userid=35532
View this thread: http://www.excelforum.com/showthread...hreadid=557582