But paul Excel allows you to enter up to 32,767 characters in each cell.
its just 411 then why the error is showing.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discuss
First thing you need to know is there is no shortcut to click that Plus
button, The functionality which is used there is autofill, But you can use
this shortcut to do the auto fill ALT+E+I+S then ALT+F enter or Ctrl+D is
the best, Best functionality of + sign pressing it copies the data to last
Suppose I want to copy it till 500,000 rows then how is it possible, if
there is possibility then first select the range (i.e. 500,000 rows) and
the press CTRL+D but i dont want to select the range, I just press the cona
of the cell so that it copies till A50, I think you understand my poin
I played around with my system date format and finally got it right.
Thanks Paul & Mandeep
On Sunday, 22 November 2015 22:40:48 UTC-5, Bill Q wrote:
>
>
>
> PSA.
>
> Can someone please create a macro for me that would eliminate this
> frustrating problem that I have with date converstion.
>
>
OK, here's a POSSIBLE solution:
Since the format of the source data does not match the current system date
format,Excel converts any source value that COULD be a date to an Excel date,
which is a number.
Any non-valid date is loaded as text.
So, we can either import the data as text and convert,o
Mandeep:
I think the problem is that his default date format is different from our
own.(and HIS default date format is different than the source date format)
I suspect his original date records are sequential:10-Oct-2015
12-Oct-2015
14-Oct-2015
16-Oct-2015
18-Oct-2015
22-Oct-2015
24-Oct-2015
26-Oc
o to convert it to a
> date in the proper format?
>
> BTW: If excel recognizes a value as a date, it converts it to a number.
> (the number of days since 1/1/1900)
> Once converted, you can DISPLAY this number in any way you'd like.
>
>
I'm sorry, I show that I sent the response directly to you.
For the group:
The problem seems to be with the multiple entry records.
The maximum number of characters that can be put in a cell is 255.
Your record #470044012 has too many duplicates.The string length becomes 411.
You will need to deci
he proper format?
BTW: If excel recognizes a value as a date, it converts it to a number.(the
number of days since 1/1/1900)Once converted, you can DISPLAY this number in
any way you'd like.
November 23, 2015 is42331
11/23/2015
Monday, November 23, 2015
23-Nov
20151123
These are all the same
What please see your dates which i copied from your sheet how 2010 year
will be 2015 ? ?
DATE1 15-10-2010 15-12-2010 10/14/15 10/16/15 10/18/15 10/22/15 10/24/15
10/26/15 10/27/15 10/29/15 15-01-2011 15-04-2011 15-06-2011 15-07-2011
15-09-2010 15-10-2010 10/14/15 10/15/15 10/17/15 10/20/15 10/2
Close but know. All dates in the "source" are actually in 2015. See my
dilemma ?
On Sunday, 22 November 2015 22:40:48 UTC-5, Bill Q wrote:
>
>
>
> PSA.
>
> Can someone please create a macro for me that would eliminate this
> frustrating problem that I have with date converstion.
>
> DAT
Hi,
What kind of combinations you're looking for? Are these combination should
result to 1200 or Less than what ??, what is the use of this code, I would
like to see the output first for some random combinations.
Regards,
Mandeep baluja
On Friday, October 23, 2015 at 12:39:21 AM UTC
Check this way !!
1. On the Project menu, click References.
2. Double-click Microsoft VBScript Regular Expressions 5.5, and then
click OK. and Run this code
Sub Reg_Ex()
Dim RegEx As Object
Set RegEx = CreateObject("VBscript.Regexp")
For Each Cell In ActiveSheet.UsedRange
Txt
13 matches
Mail list logo