Formating advanced numbers

G

Guest

How do I input a value 1.20 and keep it on 1.20 instead of 1.2 in excel? In
other words, i want a number like #.##000 or either #.#00 and keeping the
original "0" digits as typed. Not by changing the "Regional Options" in
control pannel...
 
Z

Zone

Select cell(s) to be formatted. Then select Format from the menubar,
then Cells, then on the Number tab, 2 decimal places. James
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cell reference in formula string displays abbreviated value 2
Custom number format #,##0.## yields extra '.' when formattingintegers 3
Simple conversion 4
social security numbers in Excel 3
Australian Telephone Numbers 3
Unable to sort "words" that are numbers and letters 5
Formating Numbers 11
Negative Numbers in Parentheses 2

Top