Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automatically entered decimal point.
I enter a lot of currency with cents and have to pick-up the decimal point
when the cents is not 00. Is there a way that I could simply enter a number such as $43785 and have the decimal point be automatically positioned between the 7 and 8 so that it read $437.85? For a product as sophisticated as Excel, especially since it works with money, one would think that this would be one of the first formatting options available with a cell that concerns numbers and money. Hope someone can offer a solution! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automatically entered decimal point.
Yes, you can do this. Click on Tools | Options | Edit (tab) and check
Fixed Decimal with 2 places, then OK. Enter the following values in some cells: 123 -- displayed as 1.23 1234 -- displayed as 12.34 12345 -- displayed as 123.45 Note that if you have no cents, you will still have to enter 00 at the end of the dollars. It is probably better to de-select this option once you have finished. Hope this helps. Pete J.G.Martin wrote: I enter a lot of currency with cents and have to pick-up the decimal point when the cents is not 00. Is there a way that I could simply enter a number such as $43785 and have the decimal point be automatically positioned between the 7 and 8 so that it read $437.85? For a product as sophisticated as Excel, especially since it works with money, one would think that this would be one of the first formatting options available with a cell that concerns numbers and money. Hope someone can offer a solution! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automatically entered decimal point.
Thanks Pete. I'm now experimenting with overriding columns to zero decimal
points to see if that will take precident over the edit. I just knew that there had to be a way! I appreciate the quick reply too! "Pete_UK" wrote: Yes, you can do this. Click on Tools | Options | Edit (tab) and check Fixed Decimal with 2 places, then OK. Enter the following values in some cells: 123 -- displayed as 1.23 1234 -- displayed as 12.34 12345 -- displayed as 123.45 Note that if you have no cents, you will still have to enter 00 at the end of the dollars. It is probably better to de-select this option once you have finished. Hope this helps. Pete J.G.Martin wrote: I enter a lot of currency with cents and have to pick-up the decimal point when the cents is not 00. Is there a way that I could simply enter a number such as $43785 and have the decimal point be automatically positioned between the 7 and 8 so that it read $437.85? For a product as sophisticated as Excel, especially since it works with money, one would think that this would be one of the first formatting options available with a cell that concerns numbers and money. Hope someone can offer a solution! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automatically entered decimal point.
Thanks for feeding back.
Pete J. G. Martin wrote: Thanks Pete. I'm now experimenting with overriding columns to zero decimal points to see if that will take precident over the edit. I just knew that there had to be a way! I appreciate the quick reply too! "Pete_UK" wrote: Yes, you can do this. Click on Tools | Options | Edit (tab) and check Fixed Decimal with 2 places, then OK. Enter the following values in some cells: 123 -- displayed as 1.23 1234 -- displayed as 12.34 12345 -- displayed as 123.45 Note that if you have no cents, you will still have to enter 00 at the end of the dollars. It is probably better to de-select this option once you have finished. Hope this helps. Pete J.G.Martin wrote: I enter a lot of currency with cents and have to pick-up the decimal point when the cents is not 00. Is there a way that I could simply enter a number such as $43785 and have the decimal point be automatically positioned between the 7 and 8 so that it read $437.85? For a product as sophisticated as Excel, especially since it works with money, one would think that this would be one of the first formatting options available with a cell that concerns numbers and money. Hope someone can offer a solution! |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automatically entered decimal point.
Pete,
I've tried to find out how to rate this, but my thanks will have to be sufficient. I gave up trying to find the link. Thanks again! "Pete_UK" wrote: Thanks for feeding back. Pete J. G. Martin wrote: Thanks Pete. I'm now experimenting with overriding columns to zero decimal points to see if that will take precident over the edit. I just knew that there had to be a way! I appreciate the quick reply too! "Pete_UK" wrote: Yes, you can do this. Click on Tools | Options | Edit (tab) and check Fixed Decimal with 2 places, then OK. Enter the following values in some cells: 123 -- displayed as 1.23 1234 -- displayed as 12.34 12345 -- displayed as 123.45 Note that if you have no cents, you will still have to enter 00 at the end of the dollars. It is probably better to de-select this option once you have finished. Hope this helps. Pete J.G.Martin wrote: I enter a lot of currency with cents and have to pick-up the decimal point when the cents is not 00. Is there a way that I could simply enter a number such as $43785 and have the decimal point be automatically positioned between the 7 and 8 so that it read $437.85? For a product as sophisticated as Excel, especially since it works with money, one would think that this would be one of the first formatting options available with a cell that concerns numbers and money. Hope someone can offer a solution! |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automatically entered decimal point.
I give suggestions to try to help people, not to gain rating points -
who takes any notice of them anyway? Pete J.G.Martin wrote: Pete, I've tried to find out how to rate this, but my thanks will have to be sufficient. I gave up trying to find the link. Thanks again! "Pete_UK" wrote: Thanks for feeding back. Pete J. G. Martin wrote: Thanks Pete. I'm now experimenting with overriding columns to zero decimal points to see if that will take precident over the edit. I just knew that there had to be a way! I appreciate the quick reply too! "Pete_UK" wrote: Yes, you can do this. Click on Tools | Options | Edit (tab) and check Fixed Decimal with 2 places, then OK. Enter the following values in some cells: 123 -- displayed as 1.23 1234 -- displayed as 12.34 12345 -- displayed as 123.45 Note that if you have no cents, you will still have to enter 00 at the end of the dollars. It is probably better to de-select this option once you have finished. Hope this helps. Pete J.G.Martin wrote: I enter a lot of currency with cents and have to pick-up the decimal point when the cents is not 00. Is there a way that I could simply enter a number such as $43785 and have the decimal point be automatically positioned between the 7 and 8 so that it read $437.85? For a product as sophisticated as Excel, especially since it works with money, one would think that this would be one of the first formatting options available with a cell that concerns numbers and money. Hope someone can offer a solution! |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automatically entered decimal point.
I give suggestions to try to help people, not to gain rating points -
who takes any notice of them anyway? Your thanks are enough, and I'm glad you've learnt something new. Pete (ex lecturer) J.G.Martin wrote: Pete, I've tried to find out how to rate this, but my thanks will have to be sufficient. I gave up trying to find the link. Thanks again! "Pete_UK" wrote: Thanks for feeding back. Pete J. G. Martin wrote: Thanks Pete. I'm now experimenting with overriding columns to zero decimal points to see if that will take precident over the edit. I just knew that there had to be a way! I appreciate the quick reply too! "Pete_UK" wrote: Yes, you can do this. Click on Tools | Options | Edit (tab) and check Fixed Decimal with 2 places, then OK. Enter the following values in some cells: 123 -- displayed as 1.23 1234 -- displayed as 12.34 12345 -- displayed as 123.45 Note that if you have no cents, you will still have to enter 00 at the end of the dollars. It is probably better to de-select this option once you have finished. Hope this helps. Pete J.G.Martin wrote: I enter a lot of currency with cents and have to pick-up the decimal point when the cents is not 00. Is there a way that I could simply enter a number such as $43785 and have the decimal point be automatically positioned between the 7 and 8 so that it read $437.85? For a product as sophisticated as Excel, especially since it works with money, one would think that this would be one of the first formatting options available with a cell that concerns numbers and money. Hope someone can offer a solution! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
3.02 PM ( Decimal Point )to 1502 | Excel Worksheet Functions | |||
Numbers entered are being automatically converted ? | Excel Discussion (Misc queries) | |||
can entered data in sheet 1 be automatically pasted in sheet 2 | Excel Discussion (Misc queries) | |||
how do I stop excel putting a space after a decimal point | Excel Discussion (Misc queries) | |||
Why am I getting .+ when I hit the decimal point? | Excel Discussion (Misc queries) |