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.

Hi

ToolsOptionsEdituncheck Fixed Decimal places

--
Regards

Roger Govier


"ClaireView" wrote in message
...
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.

Toolsoptionsedit, deselect fixed decimal places


--
Regards,

Peo Sjoblom



"ClaireView" wrote in message
...
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.

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

HTH,

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

"ClaireView" wrote in message
...
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.

You guys rock! Thanks for the quick responses!
Claire