cell format type 16 characters int cell and program changes lost # to 0

%3CLINGO-SUB%20id%3D%22lingo-sub-2413850%22%20slang%3D%22en-US%22%3Ecell%20format%20type%2016%20characters%20int%20cell%20and%20program%20changes%20lost%20%23%20to%200%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2413850%22%20slang%3D%22en-US%22%3E%3CP%3Ewhy%20will%20it%20not%20allow%20my%20to%20type%20in%20the%20correct%20data%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2413850%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2414242%22%20slang%3D%22en-US%22%3ERe%3A%20cell%20format%20type%2016%20characters%20int%20cell%20and%20program%20changes%20lost%20%23%20to%200%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2414242%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1070624%22%20target%3D%22_blank%22%3E%40John_C_Pugh%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EExcel%20only%20calculates%20with%20numbers%20up%20to%2015%20digits.%20Better%20said%2C%20numbers%20with%20more%20than%2015%20digits%20are%20rounded%20to%2015%20digits.%3C%2FP%3E%0A%3CP%3EIf%20this%20is%20a%20credit%20card%20number%2C%20then%20you%20probably%20do%20not%20need%20to%20make%20calculations%20with%20it.%20If%20that's%20the%20case%2C%20make%20sure%20to%20format%20the%20cell%20as%20Text%20before%20you%20type%20the%20number%20in%20it.%20This%20way%20you%20will%20get%20all%20the%2016%20digits%20in%20it.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Celia_Alves_0-1622751269280.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F286122iEB2AAB4476F395E7%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Celia_Alves_0-1622751269280.png%22%20alt%3D%22Celia_Alves_0-1622751269280.png%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Celia_Alves_1-1622751370594.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F286123i66F7334F34F67A6A%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Celia_Alves_1-1622751370594.png%22%20alt%3D%22Celia_Alves_1-1622751370594.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

why will it not allow my to type in the correct data?

 

1 Reply

@John_C_Pugh 

Excel only calculates with numbers up to 15 digits. Better said, numbers with more than 15 digits are rounded to 15 digits.

If this is a credit card number, then you probably do not need to make calculations with it. If that's the case, make sure to format the cell as Text before you type the number in it. This way you will get all the 16 digits in it.

Celia_Alves_0-1622751269280.pngCelia_Alves_1-1622751370594.png