Excell Issue

Highlighted
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
Highlighted

Hello @annz-2020,

 

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

Highlighted

Hi @annz-2020,

 

Try formatting the cell as Special>Social Security Number.

Bennadeau_0-1595531736987.png

 

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

@annz-2020

 

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

Highlighted

@PReagan 

That worked thank you!

Highlighted

@annz-2020 

 

Good! Happy to help!