Sorry, didn't mean to move the goalposts!
I'm now thinking of a new method: it's only the cells that are automatically interpreted as dates that screw up, so is there a way to force every single cell to come through as text?
Hi strongm,
Many thanks for your help - I'm guessing that changing to a 4 is designed to affect the date column. The problem is that the date could be in any column.
The Excel tool is designed to deal with any form and so the date could be anywhere, not necessarily the fourth column.
Let...
Many thanks for your speedy response. My problem is that I work in a big company and many people use the Email-to-Excel tool. So there's no way I can set everyone's computers :)
I was thinking that ideally I'd be able to check for columns that are in the following format:
number...
Hi there,
I'd be really grateful for any help with sorting out the date format in my Outlook to Excel importer.
Background
I've got an online form, and when the user submits it their response is sent to my email address.
I receive the form responses in the following format, with a...
Hi,
Yeah I have got a javascript one and I've also made a Flash clock, but both of those involve updating daylight savings time. That's a problem when not all countries' clocks change on the same date and when the DST date changes from year to year!
Not knowing much about asp, I wondered if...
Hi,
Yeah I have got a javascript one and I've also made a Flash clock, but both of those involve updating daylight savings time. That's a problem when not all countries' clocks change on the same date and when the DST date changes from year to year!
Not knowing much about asp, I wondered if...
Hi Chopstik,
Good point! Here is the message that appears in place of the clock:
The page cannot be displayed
There is a problem with the page you are trying to reach and it cannot be displayed.
--------------------------------------------------------------------------------
Please try the...
Hi there,
I need to make a world clock to put on a website. At the moment, I have a JavaScript clock where the user can select a time zone from a drop down menu and the digital clock changes accordingly.
The problem is daylight saving time. Different countries change their time on different...
Do you know how I can add a ... to the end of the text?
At the moment the words are chopping off mid word.
e.g. the lady tripped over the c
It would be better if it said
the lady tripped over the c...
Many thanks for your help,
Katie
Hi there,
I have a web page with an include to a news article. So the whole news article is shown on the page. I would like only the first 200 characters to show, not the whole thing, so I have tried using the following code. However, I'm not having any success.
JavaScript
function...
Hi there,
I'm using the following script which allows users to choose the time zone of a javascript clock.
Choose time zone:
<form name="where">
<select name="city" size="1" onchange="updateclock(this);">
<option value="" selected>Local time</option>
<option value="0">London GMT</option>...
Hi there,
I have a button to a feedback form on every page on my site. The problem is that if users make a comment about a page, I can't tell what page they're talking about.
I would like to add a hidden form field on my feedback form where the value is the url of the previous page...
Hi Jeff,
Thanks for your help. I can see why what you've written would make sense, but it doesn't seem to work for me. I copied the re-worked rowCount function above and pasted it over my existing one, but the count doesn't work as I would expect.
When I type 'Row 1' in the search box...
Hi there,
I'm using some JavaScript which adds a filter to my table. It works well - as the user types in the search box, the table rows appear and disappear dynamically to show only the rows which contain text that matches what the user types in.
I would like to add a counter next to the...
Hi there,
The following code brings up an alert message if the user enters something into a textbox that isn't in an array. It works fine, but I do not want the alert message to appear if a box is blank, i.e. blank is an acceptable input.
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01//EN"...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.