LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 407
Default Date Problems

Someone has sent me a huge spreadsheet with a column full of dates. Well,
not really, each date has a blank space in front of it, so I guess even
though it may say 02/23/2004, it is really just a label.

I need to have the dates so I can subtract them from one another, etc.

I would like to have a macro that can go down the column (say start in cell
c5 and go down as far as c4000 and remove the space in front of each entry.
Can someone tell me how to write that macro?

Thanks much!
Dean


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Date problems Gerry[_2_] Setting up and Configuration of Excel 1 September 28th 07 12:42 PM
date problems piute Excel Discussion (Misc queries) 14 December 7th 06 03:22 PM
Date problems, is it a bug??? R-P Excel Discussion (Misc queries) 4 August 18th 06 03:40 PM
Date problems MrEMann Excel Worksheet Functions 4 August 25th 05 04:42 PM
Date Problems MikePiehl Charts and Charting in Excel 2 June 2nd 05 05:45 PM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"