Posted to microsoft.public.excel.misc

external usenet poster

Posts: 7

Data Entry problem

Hi all,

When I try to type in "1:500" without any formula in it plain text excel
return a value of "0.388888889". Why is that and what is the colon mean. I
try to work it out i got no clue how excel got that value.

Thanks in advance

Jason

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
Excel data import problem	msnews.microsoft.com	Excel Worksheet Functions	1	June 26th 06 12:24 PM
Import external data problem	ardi	Excel Discussion (Misc queries)	1	April 3rd 06 02:03 PM
Data Entry problem	Ray A	Excel Discussion (Misc queries)	0	November 10th 05 12:28 AM
Problem organizing text data into new excel page	Tony	Excel Worksheet Functions	3	October 21st 05 08:19 PM
Sort pages?	David	Excel Discussion (Misc queries)	15	May 13th 05 11:33 PM

All times are GMT +1. The time now is 08:18 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us