View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob in Charlotte
 
Posts: n/a
Default Importing data, and need formatting advice

Thanks for the replies Gord & wjohnson. Those suggestions of copy/paste
special or importing the data from a txt file worked. Only thing is that I
want to automate it to refresh the data when opening up the file on Monday &
Tuesday mornings, after the games take place, but one does refresh the data,
it reverts back again to the date format.

Is their any formatting function I can apply to those cells to convert the
date format to a number to where the data shows up as 7-2 (whatever the
record.)

By the way, my apologies for the duplicate post. I put one post in via
usenet, then posted another post in this web forum, and wasn't aware that it
replicates to usenet till I saw the second post.

Bob

"Gord Dibben" wrote:

Bob

<snipped