Home

Help on input of number in excel cell

michael samson
Occasional Visitor

Hi,

 

While using excel if i type this digit in any cell 2017272505089170001 i get the number as 

2.01727E+18

 

how can i change this to get the number that i want to type. file attached

 

thank yo

1 Reply
Highlighted

Go to Home Ribbon tab >> Number Group

Then choose the Number format from the combo box.

 

In short, select the number and press Ctrl+Shift+1

 

There is an idea related to this topic found here.

It suggests stopping Excel from changing large numbers to scientific notation.
I advise you to vote for it.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies