showing total of 10 digits.

  • Thread starter Thread starter Thrava
  • Start date Start date
T

Thrava

hi group,
I need to show 10 digits total of any number (with last 2
being the decimals).
So if the cell contains the number 6, I need it to show as
0000000600.

Or for example if the number in the cell is 103.89 it'll
show as: 0000010389

how do I make excel do that?
Thanks
 
Hi Thrava!

=A1*100
Format > Cells > Custom format 0000000000
OK
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Thrava

Don't know if you can get a custom format to do this. Have not ssen it but
there are many things I have not seen<g>

A work-around if you want.......

Enter 100 in a cell. Copy it and select your range then Paste
Special>Multiply>OK>Esc.

Now Format>Cells>Custom 0000000000

Gord Dibben Excel MVP
 
Works,
Thanks very much
-----Original Message-----
Thrava

Don't know if you can get a custom format to do this. Have not ssen it but
there are many things I have not seen<g>

A work-around if you want.......

Enter 100 in a cell. Copy it and select your range then Paste
Special>Multiply>OK>Esc.

Now Format>Cells>Custom 0000000000

Gord Dibben Excel MVP





.
Click to expand...
 
Work,
Thanks very much

-----Original Message-----
Hi Thrava!

=A1*100
Format > Cells > Custom format 0000000000
OK
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.



.
Click to expand...
 
Back
Top