ExcelBanter - How to convert 1.25 into million (1,250,000)?

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How to convert 1.25 into million (1,250,000)? (https://www.excelbanter.com/excel-discussion-misc-queries/446616-how-convert-1-25-into-million-1-250-000-a.html)

dreamer76

How to convert 1.25 into million (1,250,000)?

Hi,

Instead of using formula, can I use custom to format the whole spreadsheet?

For example, to convert 1.25 into million (1,250,000)?

Any help is highly appreciated.

All times are GMT +1. The time now is 04:00 PM.