Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Regarding Microsoft Excel
Excel thinks you're trying to enter a date. Put an apostrophe to the left of
the numbers, like this: '0 4-9 or '5-9 to force XL to treat the numbers as text and not as a date. Dave -- Brevity is the soul of wit. "Maninath K" wrote: Hi, This is Mani,, When i type in Excel sheet as 0-4, 5-9 then immediately i get -- 9-May. How to come out this kind of issues... any suggestions. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Open Dialog Improper Sort | Excel Discussion (Misc queries) | |||
enable automatic refresh | Excel Worksheet Functions | |||
Installing: Microsoft Excel Feature | Excel Discussion (Misc queries) | |||
Microsoft Excel Viewer 2003 won't open Microsoft Excel Worksheet | Excel Discussion (Misc queries) | |||
Excel instance used with "Export to Microsoft Excel" option in Internet Explorer | Excel Discussion (Misc queries) |