Posted to microsoft.public.excel.programming

Serge[_4_] Serge[_4_] is offline

external usenet poster

Posts: 4

Anomaly, can't format cell

Neight fom GUI nor VBA.

searched google groups found semi-solution:
<<
Type the number 1 in any empty cell (make sure that the
NumberFormat of the
cell with the number 1 is General or Number)
Copy it
Select all problematic date cells
Paste Special = Operation | Multiply

It worked. Question is why and how to fix it.
The cell formula contains RTD function.

Thank you.

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
Formula anomaly	Bob	Excel Worksheet Functions	7	February 8th 10 02:03 AM
Date anomaly	HaoHoaMastercard	Excel Discussion (Misc queries)	4	October 11th 07 08:05 PM
Sort anomaly	supersheet	Excel Worksheet Functions	0	August 28th 07 06:57 PM
VLOOKUP Anomaly	Tosca	Excel Worksheet Functions	6	May 8th 05 09:08 AM
Counta anomaly	stimpy[_2_]	Excel Programming	1	July 10th 03 06:54 PM

All times are GMT +1. The time now is 10:01 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us