How to do Dotted number Real time

%3CLINGO-SUB%20id%3D%22lingo-sub-3015011%22%20slang%3D%22en-US%22%3EHow%20to%20do%20Dotted%20number%20Real%20time%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3015011%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20An%20Undergraduate%20majoring%20In%20Accounting%20From%20Indonesia%3CBR%20%2F%3EI%20Work%20with%20a%20lot%20-%20a%20lot%20of%20numbers.%20And%20it's%20such%20a%20hassle%20to%20count%20the%20zeros%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Darell2330_0-1638205239942.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F330068i090D12ECDB7BA491%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Darell2330_0-1638205239942.png%22%20alt%3D%22Darell2330_0-1638205239942.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EI%20already%20Format%20the%20Cell%20and%20when%20I%20pressed%20to%20enter%20the%20Number%20become%20like%20this%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Darell2330_1-1638205414633.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F330069iAC4190FD3CB842AF%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Darell2330_1-1638205414633.png%22%20alt%3D%22Darell2330_1-1638205414633.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EBut%20i%20need%20to%20press%20enter%20and%20count%20up%20the%20zero%20to%20know%20how%20many%20zeros%20i%20put%20in.%3CBR%20%2F%3EIs%20there%20no%20way%20for%20me%20to%20The%20dot%20Appear%20in%20real-time%20so%20I%20can%20count%20precisely%20how%20many%20zeroes%20I%20put%20in%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3015011%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20Scripts%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3015485%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20do%20Dotted%20number%20Real%20time%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3015485%22%20slang%3D%22en-US%22%3EIf%20I%20understand%20correctly%20you%20want%20the%20comma%20(or%20period)%20to%20show%20up%20while%20typing%20the%20number%20so%20it%20is%20easier%20to%20count%20the%20number%20of%20zeros%20while%20entering%20the%20number.%20The%20answer%20to%20that%20is%20no%2C%20that%20is%20not%20possible%20but%20if%20it%20is%20just%20adding%20zeros%20at%20the%20end%20of%20the%20number%20then%20you%20can%20just%20add%20e%23%20where%20%23%20is%20the%20number%20of%20zeros%20you%20want%20to%20add.%20So%20in%20your%20example%20for%20600%2C000%20you%20could%20type%206e5%20instead.%20This%20will%20cause%20excel%20to%20format%20it%20in%20scientific%20notation%20(6.00E%2B05)%20but%20then%20at%20the%20end%20you%20can%20highlight%20the%20column%20and%20select%20the%20correct%20format.%3C%2FLINGO-BODY%3E
Occasional Visitor

I'm An Undergraduate majoring In Accounting From Indonesia
I Work with a lot - a lot of numbers. And it's such a hassle to count the zeros 

Darell2330_0-1638205239942.png

I already Format the Cell and when I pressed to enter the Number become like this 

Darell2330_1-1638205414633.png

But i need to press enter and count up the zero to know how many zeros i put in.
Is there no way for me to The dot Appear in real-time so I can count precisely how many zeroes I put in?

 

1 Reply
If I understand correctly you want the comma (or period) to show up while typing the number so it is easier to count the number of zeros while entering the number. The answer to that is no, that is not possible but if it is just adding zeros at the end of the number then you can just add e# where # is the number of zeros you want to add. So in your example for 600,000 you could type 6e5 instead. This will cause excel to format it in scientific notation (6.00E+05) but then at the end you can highlight the column and select the correct format.