Display the number as it was typed

[dparteka]

Is it possible to have Excel display a number exactly the way it is typed in a cell, for example.
Enter 1 and Excel displays 1 this is good
Enter 1.0 and Excel displays 1 we need it to display 1.0
Enter 1.00 and Excel displays 1 we need it to display 1.00
Enter 1.000 and Excel displays 1 we need it to display 1.000
Enter 1.0000 and Excel displays 1 we need it to display 1.0000

All cells are formatted as General with no decimal place specified since the entries will vary from cell to cell.

 

[Luke M]

Not directly, but some possible ideas...

Option a)
Format the cells as text before entering data, and then type whatever you want. XL will preserve the writing exactly as you type. Negative is that you now have numbers stored as text, and will may to convert them (via formulas) before using the values elsewhere like in a SUM.

Option b)
You really are conveying two bits of information. The value, and level of significant digits. We could use 2 cells to do this, type the value in one, and the # of sigs in another, and then use
=TEXT(A2,"0." & REPT(0,B2))
to display the number correctly. You could then reference cell A2 in calculations, but formula cell (assume it's C3) could be used to display desired effect.

 

[dparteka]

Thanks Luke M... I'll play around with your suggestions