Too simple?
- Thread starter J Symank
- Start date
Hi J Symank,
Welcome to Chandoo.org
Is it always two digits you enter or anyvalue you enter should be divided by ten?
You can use a helper column i.e.
If you want the 3.4 to come in Col B, then have the data entered in Col C and in Col B have the formula:
=C1/10
This should probably help you.
Regards,
Prasad DN
Welcome to Chandoo.org
Is it always two digits you enter or anyvalue you enter should be divided by ten?
You can use a helper column i.e.
If you want the 3.4 to come in Col B, then have the data entered in Col C and in Col B have the formula:
=C1/10
This should probably help you.
Regards,
Prasad DN
Under Excel Options, on the Advanced pane, there's a check box to automatically insert a decimal point after x digits. Check the box and set the digits to 1.
In 2003, I believe it's found under Tools - Options - Edit.
Note that this would affect the input of all cells until you turn this off.
If you just want the change the appearance, you might be able to the method discussed here:
http://chandoo.org/wp/2012/01/31/custom-number-formats-multiply-divide-by-any-power-of-10/
In 2003, I believe it's found under Tools - Options - Edit.
Note that this would affect the input of all cells until you turn this off.
If you just want the change the appearance, you might be able to the method discussed here:
http://chandoo.org/wp/2012/01/31/custom-number-formats-multiply-divide-by-any-power-of-10/