ExcelBanter - custom number format

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

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

- - custom number format (https://www.excelbanter.com/excel-discussion-misc-queries/160478-custom-number-format.html)

Dave F[_2_]

custom number format

Say I have 3,510,00 in a cell.

How can I have it displayed as 3.51?

I realize I can just multiply by 10^-6 but I want to keep the
underlying millions.

Thanks,

Dave

Gary''s Student

custom number format

Format Custom
0.00,,

--
Gary''s Student - gsnu2007

"Dave F" wrote:

Say I have 3,510,00 in a cell.

How can I have it displayed as 3.51?

I realize I can just multiply by 10^-6 but I want to keep the
underlying millions.

Thanks,

Dave

All times are GMT +1. The time now is 06:02 AM.