Formatting Numeric Decimal 9.6

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
devdog said:
I am trying to format a column on my spreadsheet with something called
Click to expand...
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
Click to expand...

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).
 
Back
Top