Forum Discussion
numbers in formatting v accounting
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
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
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
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
Hello, ExcelExciting,
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