Excell Issue

%3CLINGO-SUB%20id%3D%22lingo-sub-1542315%22%20slang%3D%22en-US%22%3EExcell%20Issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1542315%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20put%20social%20security%20numbers%20in%20a%20spread%20sheet%20with%20no%20dashes%20and%20I%20keep%20trying%20to%20format%20the%20cell%20to%20general%20numbers%20but%20it%20keeps%20adding%20a%20decimal%20hw%20can%20I%20correct%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1542315%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1542342%22%20slang%3D%22en-US%22%3ERe%3A%20Excell%20Issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1542342%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F738144%22%20target%3D%22_blank%22%3E%40annz-2020%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EInstead%20of%20the%20Numbers%20format%2C%20try%20using%20either%20General%20or%20Text.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1542349%22%20slang%3D%22en-US%22%3ERe%3A%20Excell%20Issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1542349%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F738144%22%20target%3D%22_blank%22%3E%40annz-2020%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETry%20formatting%20the%20cell%20as%20Special%26gt%3BSocial%20Security%20Number.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Bennadeau_0-1595531736987.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F207540i2E936F9DC887FCC0%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Bennadeau_0-1595531736987.png%22%20alt%3D%22Bennadeau_0-1595531736987.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1542352%22%20slang%3D%22en-US%22%3ERE%3A%20Excell%20Issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1542352%22%20slang%3D%22en-US%22%3Ewhen%20I%20select%20those%20the%20populate%20the%20number%20with%20the%20decimal%20and%20there%20are%20no%20other%20options%20for%20me%20to%20choose%20from%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1542359%22%20slang%3D%22en-US%22%3ERE%3A%20Excell%20Issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1542359%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F738144%22%20target%3D%22_blank%22%3E%40annz-2020%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHmm...%20this%20should%20not%20be%20happening.%20An%20alternative%20would%20be%20to%20simply%20use%20the%20Custom%20format%20type%200%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1542369%22%20slang%3D%22en-US%22%3ERE%3A%20Excell%20Issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1542369%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F360420%22%20target%3D%22_blank%22%3E%40PReagan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThat%20worked%20thank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1542379%22%20slang%3D%22en-US%22%3ERE%3A%20Excell%20Issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1542379%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F738144%22%20target%3D%22_blank%22%3E%40annz-2020%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGood!%20Happy%20to%20help!%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I am trying to put social security numbers in a spread sheet with no dashes and I keep trying to format the cell to general numbers but it keeps adding a decimal hw can I correct this?

6 Replies

Hello @annz-2020,

 

Instead of the Numbers format, try using either General or Text.

Hi @annz-2020,

 

Try formatting the cell as Special>Social Security Number.

Bennadeau_0-1595531736987.png

 

when I select those the populate the number with the decimal and there are no other options for me to choose from

@annz-2020

 

Hmm... this should not be happening. An alternative would be to simply use the Custom format type 0

@PReagan 

That worked thank you!

@annz-2020 

 

Good! Happy to help!