Menu

excel 2002 formatting problem

Search this Thread

Prev

Previous Post

Next Post

Next

#2

Report Post

Posted to microsoft.public.excel.misc

Ron Rosenfeld Ron Rosenfeld is offline

Ron Rosenfeld is offline

external usenet poster

Posts: 5,651

Default

excel 2002 formatting problem

On 24 Apr 2007 18:44:07 -0700, wrote:

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.

Check your Windows Regional Settings

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

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Conditional Formatting (Excel 2002 SP3)	vertigo	Excel Worksheet Functions	5	April 20th 07 10:24 AM
Basic problem with EXCEL 2002	[email protected]	Excel Discussion (Misc queries)	1	October 24th 06 12:16 AM
Iteration problem (Excel 2002)	Stefan Kasserra	Excel Worksheet Functions	1	July 17th 06 11:38 PM
Conditional formatting.... Excel 2002	Gunjani	Excel Worksheet Functions	1	February 13th 06 10:58 AM
Excel 2002 Date Formatting	skoladycz	Excel Discussion (Misc queries)	1	April 6th 05 06:43 PM

All times are GMT +1. The time now is 09:33 PM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement