Formating pre-sets are all wrong

G

Guest

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.
 
R

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copying SSNs to new format 6
merging 2 sets of code 4
Modifying Ron's Sub Copy_To_Workbooks 2
How can I display a warning if calculations indicate original data may be wrong? 2
Progamatically Formating Cells within VSTO for Excel Application Development using C# 5
lotto numbers 2
Getting All Data On Chart 1
The Search Key was not found in any record... 0

Top