excel 2002 formatting problem

  • Thread starter Thread starter srgyrm
  • Start date Start date
S

srgyrm

Excel displays and treats numbers with decimal point as dates (1.1
displays as 01.jan, for example). Cell formatting does not help.
Replacing whole MS Office with another copy, which worked fine on
another computer, also did not have any effect. What could it be and
how to solve the problem? Thank you very much.
 
Excel displays and treats numbers with decimal point as dates (1.1
displays as 01.jan, for example). Cell formatting does not help.
Replacing whole MS Office with another copy, which worked fine on
another computer, also did not have any effect. What could it be and
how to solve the problem? Thank you very much.
Click to expand...

Check your Windows Regional Settings

Start/Control Panel/Date Time .../Regional Options
--ron
 

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

Why this paste result? 4
CSV->Excel Data Problem 1
Cell formatting error, Excel 2003 3
Addition in Excel 2
Mail Merge - Thousand separators & Decimals 0
Mail Merge - Thousand separator and decimals 1
Date Time formatting problem 7
Custom 0\.00 Format with Comma 4

Back
Top