SOLVED

numbers in formatting v accounting

%3CLINGO-SUB%20id%3D%22lingo-sub-1396289%22%20slang%3D%22en-US%22%3Enumbers%20in%20formatting%20v%20accounting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1396289%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20building%20a%20personalized%20itemized%20deduction%20spreadsheet%20and%20would%26nbsp%3B%3CEM%3E%3CSTRONG%3Elike%3C%2FSTRONG%3E%3C%2FEM%3E%3CSPAN%3E%26nbsp%3Bto%20to%20set%20decimals%20as%20if%20I%20am%20using%20an%20adding%20machine%20at%20the%20%2B%20decimal%20setting.%20I%20have%20a%20tremor%2C%20and%20wish%20to%20have%20my%20decimal%20placed%20without%20having%20to%20type%20the%20decimal%20myself.%20For%20example%2C%20if%20I%20were%20to%20type%201257%20into%20a%20cell%20in%20an%20%22accounting%22%20formatted%20column%2C%20the%20value%20entered%20would%20ideally%20be%20%2412.57%20and%20not%20%241%2C257.00.%20Can%20this%20be%20done%20in%20Excel%3F%20I%20tried%20changing%20decimal%20setting%20by%20using%20buttons%20beneath%20the%20%22general%2Fnumber%2Fcurrency%2Faccounting%22%20format%20menu%2C%20but%20that%20merely%20changes%20how%20many%20decimal%20places%20show%20in%20cells.%20My%20tremor%20makes%20data%20entry%20laborious%2C%20and%20eliminating%20the%20need%20to%20press%20the%20decimal%20button%20would%20help%20speed%20up%20my%20process%20greatly.%20Thanks%20for%20any%20help!!%20-Ginny%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1396289%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1396316%22%20slang%3D%22en-US%22%3ERe%3A%20numbers%20in%20formatting%20v%20accounting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1396316%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F670246%22%20target%3D%22_blank%22%3E%40Ginny940%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20is%20possible%20with%20Excel%20all%20you%20need%20to%20do%20is%20goto%20%3CSTRONG%3EFILE%20%26gt%3B%20OPTION%20%26gt%3B%20ADVANCE%20%26gt%3B%20EDITING%20OPTIONS%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3Echeck%20the%20box%20%22Automatically%20insert%20a%20decimal%20point%22.%20You%20can%20just%20enter%20the%20value%20and%20Excel%20will%20automatically%20place%20the%20decimal.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBelow%20is%20video%20link%20for%20your%20refer%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fyoutu.be%2FUm44m7HnqqE%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fyoutu.be%2FUm44m7HnqqE%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ERegards%2C%20Faraz%20Shaikh%20%7C%20MCT%2C%20MIE%2C%20MOS%20Master%2C%20Excel%20Expert%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CEM%3E%3CFONT%20color%3D%22%23808080%22%3EIf%20you%20find%20the%20above%20solution%20resolved%20your%20query%20don't%20forget%20mark%20as%26nbsp%3B%3CSPAN%3EOfficial%20Answer%26nbsp%3Bto%20help%20the%20other%20members%20find%20it%20more%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FEM%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1398282%22%20slang%3D%22en-US%22%3ERe%3A%20numbers%20in%20formatting%20v%20accounting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1398282%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F156456%22%20target%3D%22_blank%22%3E%40Faraz%20Shaikh%3C%2FA%3E%2C%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20You!%20You%20are%20an%20angel.%20The%20world%20needs%20more%20helpful%20folk%20like%20you%2C%20my%20friend.%20I%20did%20not%20see%20an%20option%20to%20mark%20as%20%22official.%22%20Advise%20me%20how%20to%20find%20that%20option%2C%20and%20I%20will%20gladly%20do%20that%2C%20so%20that%20your%20response%20to%20my%20query%20can%20help%20many%20others%20as%20well.%3C%2FP%3E%3CP%3ESincerely%2C%3C%2FP%3E%3CP%3EGinny940%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

I am building a personalized itemized deduction spreadsheet and would like to to set decimals as if I am using an adding machine at the + decimal setting. I have a tremor, and wish to have my decimal placed without having to type the decimal myself. For example, if I were to type 1257 into a cell in an "accounting" formatted column, the value entered would ideally be $12.57 and not $1,257.00. Can this be done in Excel? I tried changing decimal setting by using buttons beneath the "general/number/currency/accounting" format menu, but that merely changes how many decimal places show in cells. My tremor makes data entry laborious, and eliminating the need to press the decimal button would help speed up my process greatly. Thanks for any help!! -Ginny

2 Replies
Highlighted
Best Response confirmed by Ginny940 (New Contributor)
Solution

Hi @Ginny940,

 

It is possible with Excel all you need to do is goto FILE > OPTION > ADVANCE > EDITING OPTIONS

check the box "Automatically insert a decimal point". You can just enter the value and Excel will automatically place the decimal.

 

Below is video link for your refer

https://youtu.be/Um44m7HnqqE

 

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official Answer to help the other members find it more

Highlighted

Hello, @Faraz Shaikh

Thank You! You are an angel. The world needs more helpful folk like you, my friend. I did not see an option to mark as "official." Advise me how to find that option, and I will gladly do that, so that your response to my query can help many others as well.

Sincerely,

Ginny940