Formating pre-sets are all wrong

[ClaireView]

I've opened a new Excel document and all the formatting is wonky. If I type
a "1" it reverts to ".01". I change the format for a column for social
security numbers, and it adds two zeros at the front: 123-45-6789 becomes
001-23-4567.

I know I can set and re-set each column, but I don't have TIME to do fight
with Excel over this! There must be something wrong with the way the
defaults have been set. Can someone help me QUICKLY change things? I'm
using Excel 2002 in Windows XP.

 

[Roger Govier]

Hi

Tools>Options>Edit>uncheck Fixed Decimal places

 

[Peo Sjoblom]

Tools>options>edit, deselect fixed decimal places

 

[RagDyeR]

<Tools> <Options> <Edit> tab,
And *Uncheck*
"Fixed Decimal Places".
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

I've opened a new Excel document and all the formatting is wonky. If I type
a "1" it reverts to ".01". I change the format for a column for social
security numbers, and it adds two zeros at the front: 123-45-6789 becomes
001-23-4567.

I know I can set and re-set each column, but I don't have TIME to do fight
with Excel over this! There must be something wrong with the way the
defaults have been set. Can someone help me QUICKLY change things? I'm
using Excel 2002 in Windows XP.

 

[ClaireView]

You guys rock! Thanks for the quick responses!
Claire