Formatting Numeric Decimal 9.6

[devdog]

I am trying to format a column on my spreadsheet with something called numeric 9.6 or numeric decimal 9.6 format with whole numbers to the left of the decimal point. For example, 100 is entered as 000000100000000; 25.12 would be 000000025120000. The column size is 15 characters. The decimal point is not visible. Any help would be appreciated

Butch

 

[Paul]

I am trying to format a column on my spreadsheet with something called

numeric 9.6 or numeric decimal 9.6 format with whole numbers to the left of
the decimal point. For example, 100 is entered as 000000100000000; 25.12
would be 000000025120000. The column size is 15 characters. The decimal
point is not visible. Any help would be appreciated.

Butch

You could format as 000000000000000 and simply divide by 1000000 in any
subsequent formulas (and include a multiplication factor of 1000000 in any
formulas in the formatted cells).