LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #13   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,934
Default month gaps counting through whole column

Yes, I confirm that the dates are like 10Aug2011
formatted as General, not as Text.


I'm beginning to think you have more in that cell than the date you are
showing us. I believe you have one or more trailing non-breaking spaces
(ASCII 160) in the cell. Try this and see if it straightens things out.
Select your cell or cells with those "dates", then press CTRL+H to bring up
the Replace dialog box. Put the cursor in the "Find what" field (make sure
the field is empty) and then hold down the ALT key while pressing the
numbers 160 on the NUMBER PAD, not on the main keyboard. Make sure the
"Replace with" field is empty. Next, click the "Options" button to display
all the options for this dialog box (assuming they are not already
displayed) and make sure the "Match entire cell contents" check box is NOT
checked, then click OK. If I am correct in my assumption, then your dates
should have been converted into real dates.

Rick Rothstein (MVP - Excel)

 
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
Return Each Last Non-blank Cell, Value 2 Column Offset, Many GAPS Jim[_14_] Excel Worksheet Functions 1 August 18th 11 06:37 PM
Stacked Column Chart with gaps! James Charts and Charting in Excel 1 November 4th 09 09:24 PM
Transpose Column With Gaps to Column With no gaps Vincent Excel Discussion (Misc queries) 9 October 1st 07 01:50 PM
Find gaps or breaks in a large column Compare Values Excel Discussion (Misc queries) 4 May 17th 07 02:19 PM
Transpose Column With Gaps to Row With No Gaps? SteveC Excel Discussion (Misc queries) 5 June 18th 05 01:01 AM


All times are GMT +1. The time now is 09:31 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"