Microsoft Office Forums - View Single Post - Entering a number of 19 digits

Thread: Entering a number of 19 digits

View Single Post

Old

11-02-2017, 03:12 AM

Jo Freeman Jo Freeman is offline

Jo Freeman is offline

Jo Freeman uses Windows 7 64bit

Windows 7 64bit Jo Freeman uses Office 2016

Jo Freeman uses Office 2016

Office 2016

Novice

The original poster

Join Date: Mar 2015

Posts: 19

Jo Freeman is on a distinguished road

Default

Entering a number of 19 digits

Hi

I know I can't enter a number longer than 15 digits, but when I alter the cells to "Text" and enter the number, I get this:

1.23457E+17

Can someone please tell me how to get the number to show in its entirety?

Many thanks,
Jo

Reply With Quote