Good day,
I have a problem of interring a long number in excel. for example when i write 441321635511 excel makes it 4.41322E+11. I changed the cell into text but the number does not change.
Thank you for your support
Good day,
I have a problem of interring a long number in excel. for example when i write 441321635511 excel makes it 4.41322E+11. I changed the cell into text but the number does not change.
Thank you for your support
Format the cell as Number, 0 decimal places
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Change the cell format from 'General' to 'Number'. If you've already changed it to 'Text' you might need to reinput the number.
it works, thank you
You're welcome. Thanks for the feedback!![]()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks