I am trying to separate dates and times in a spreadsheet through right and
left formulas. After using these two formulas, Im getting my date answer in
the format of 40,104, etc., and the time format in a similar format. I have
tried changing the format on this and all other methods I can come up with,
but nothing seems to work for me. Anybody have a suggestion on how to make
the dates and times show up in their original format/
Assume that you are having the below value in A1 cell.
It will return the resu...Subtracting dates?? AGRRRRRRRRR!!!
I am subtracting 2 dates. To keep in simple, I am just subtracting th
dates in 2 cells as I am having trouble with datedif. Anyways, when
enter the formula, =sum(a1-a2), it does the trick, but, before I hav
entered the dates I want the difference in, it put a number like -3820
in the cell. How can I get Excel to just leave the cell blank until
enter a date? Once again, thanks in advance.
mcr1's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1549
View this thread: http:/...Importing messages #6
I have a backup disk that I would like to impport from, but obviously I do
not know how. When I double-click a message, it does not recognize which
program to use to open it and takes me to an MS site. All of these have a
"Jennifer" <Jennifer@discussions.microsoft.com> wrote in message
>I have a backup disk that I would like to impport from, but obviously I do
> not know how. When I double-click a message, it does not recognize which
> program to use to open it and takes me...Import and export
Trying to salvage my data and it was suggestd I import and
export files, do I need to import and export closed
accounts as well?
Only if you want them in the new file. In order to export a closed account,
you'll need to first specify that it is open in Money.
"Mike" <email@example.com> wrote in message
> Trying to salvage my data and it was suggestd I import and
> export files, do I need to import and export closed
> accounts as well?
When I import sales data through 3CDaemon, I get cells that I of data that I
cannot use in formulas. It is like they are corrupted. But can copy the
info from cell to cell, just cannot use in formula (ex. =if(dd04="N",1,0.
Formula does not error out, but it makes no difference if N, U, or anything
else is in dd04. It answers back 0. How can I fix this ?
Just a couple of guesses (I have no idea what 3CDaemon is).
First, Get a copy of Chip Pearson's CellView Addin so that you can really
determine what's in DD04):
Second, ...Run excel when logged off.
Is it possible to run excel when I'm logged of the computer?
I have a excel document that launches a bunch of macros. I would like to
have task scheduler run it at night without me being logged in.
Is that possible?
What happens when you try? Of course if you try accessing "mapped
drives", you will have to fix that issue too.
> Is it possible to run excel when I'm logged of the computer?
> I have a excel document that launches a bunch of macros. I would like to
> have task scheduler run it at night without me being logged in...Can I export from Excel to ACT
I have a huge contact list on an Excel spreadsheet and I was hoping I would
be able to export it straight into my Act contact manager. Anyhelp would be
greatly appreciated. Thanks
Look at the ways Excel can save, and compare with what ACT can take as
input. In Excel, do File - Save as, and go through the formats shown in the
"Save as type" box. See which, if any, Act can open or import. The csv
would seem a likely one. Or txt.
mvpearl omitthisword at verizon period net
"Parm" <Parm@discuss...transfer data in excel between sheets
What I am looking to do is get a function button (or similar) on sheet 1 that
can recognise the data put in a column and upon a click of a button transfer
data held in a certain cell elsewhere and the date onto sheet 2.
If this is not possible, what the whole purpose I am trying to do is on
sheet one have a=50 fields per day, where 3 figures are entered per line, 50
lines (ie 150 pieces of data per day) which calculates the average of the 3
numbers per row, and then the average of all these numbers appears in a
seperate field on the spreadsheet (this I have already achieved.)
Then this...categories in Outlook
There must be a way to set a default category for use in
Outlook? But, I cannot find a method. Can anyone help?
...SumProduct using Date Range
I need to sum a values using multiple criteria and a date range.
Example - I need to sum the total amount of all investors that have an "N"
in the n/e column, are in a specified region, in a specified fund, and are
between the dates of 2/1/2010 through 3/1/10. Can't seem to get this to
work? Any help is greatly appreciated.
n/e Inv Date Investors Amount Fund Region
E 2/1/2010 Client 1 $250,000 1 Asia
E 2/1/2010 Client 2 $20,000 2 North America
N 2/1/2010 Client 3 $14,000 4 North America
N 2/1/2...Import TransferIN into TransferOUT... its possible?
Hi, I have RMS 1.3, its possible to import a transfer in of one store into
transfer out on my store?
Thanks in advance.
If you are running HQ, it does this for you, on the next connect to HQ.
Get Secure! - www.microsoft.com/security
You must be using Outlook Express or some other type of newsgroup reader to
see and download the file attachment. If you are not using a reader, follow
the link below to setup Outlook Express. Click on "Open with newsreader"
under the MS Retail Management System on the right.
"Aldo" <...How do i change the height and width of a single cell in Excel?
You change the height of the cell by changing the height of the entire
row, and the width of the cell by changing the width of the entire
column. The cell cannot be independently resized, because then all the
other cells wouldn't fit.
You can merge contiguous rectangular ranges together to create
super-cells. Depending on your objective, merging cells may have
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
...Opening Lotus *.123 files in Excel
Is there a convertion filter for opening Lotus *.123 files in Excel. I can
convert *.wk? files, but I am unable to open *.123 (Lotus 1-2-3 Release 9 for
"Jim Warren" <Jim Warren@discussions.microsoft.com> wrote...
>Is there a convertion filter for opening Lotus *.123 files in Excel.
>I can convert *.wk? files, but I am unable to open *.123 (Lotus 1-2-3
>Release 9 for Windows) files
The .wk? file formats predated Microsoft securing +90% market share, so way
back then they had to compete in terms of interoperability. The .123 file
format came after Mi...OUTLOOK links & pictures
My outlook received e-mails have suddenly stopped
displaying pictures and links.
Can anyone please help ??
...excel 97 xml import
I have Excel 97 and need to import a XML file. I don't know vba.
XL97 was written way before XML therefore it will not handle it. Only
XL2003 (Individual product or from Office Pro) will recognise and handle XML
Microsoft MVP - Excel
"Slinger" <Slinger@discussions.microsoft.com> wrote in message
>I have Excel 97 and need to import a XML file. I don't know vba.
...Investmnet transactions by tx date vs. settlement date?
When I download broker transacitons, they appear to be recorded base dupon
the settlement date rather than the transaction date. This can confuse me as
the difference is up to 5 days (sometimes seems like more). Is there a way
to set the default to record and track transactions by the trade date rather
than the date the trade settles?
In microsoft.public.money, spacebased wrote:
>When I download broker transacitons, they appear to be recorded base dupon
>the settlement date rather than the transaction date. This can confuse me as
>the difference is up to 5 days (sometimes s...Importing Dynamic data
I have some tables in various xl files, call the files a,b and c. I
want to import all these into a single xl file called e. If changes
are made to a,b or c I want it to automatically update e.
I have used the import function in d but if I change a,b or c to see
the change I have to select the data in d and press refresh.
Furthermore when I refresh d i have to have files a,b and c open
otherwise it says connection lossed and is unable to refresh the data.
Can someone explain to me in simple terms what I have to do in order to
get the data automatically updated without having to alway...recover damaged excel file
I have a workbook creater with Excel 2000 just a few days ago but there's no
way to open it. Coud anyone give me any suggestion?
what message do you get?, ask your IT department usually they backup all the
files, did you send the file to somebody?
> I have a workbook creater with Excel 2000 just a few days ago but there's no
> way to open it. Coud anyone give me any suggestion?
Thank you Eduardo.
I don't get any error message, the file just doesn't open. Unfortunatately
we backup files only once a month and I created...syncing excel 2007...
hi all community members...
I have excel 2007 and sync all my
office 2007 files to a online backup.
unfortunately for excel this is not done
I have to restart my computer
(windows ultimate) for it to be synced
(the company is ‘humyo’ which I think is
one of the best...)
I phoned them up and was told I must
have ‘some sort of lock’ on these
I have been through the settings and thought
it was privacy/personal information
but am lost.
can someone please help and I look
forward to a reply.
very much appreciated.
I can't think of anyth...how do I convert date format yyyymmdd to mm/dd/yyyy
how do I convert date format yyyymmdd to mmddyyy
I have rows of dates displayed as yyyymmdd (ie 20100131)
I want them displayed as regular dates (ie 01/31/2010)
If it's a column of cells...
Select the column
Data|text to columns (in xl2003 menus)
choose fixed width, but don't have any delimiter lines
Choose Date (ymd)
This will convert the data to dates.
Now you can format the ranyge the way you like.
> how do I convert date format yyyymmdd to mmddyyy
> I have rows of dates displayed as yyyymmdd (ie 20100131)
> I wan...how do I type over a pic on excel
Unless you put the picture in the Background (Format/Sheet/Background),
in which case it will be tiled throughout the entire sheet, you can't
directly type over a picture because pictures "live" in the Drawing
layer above the cells.
You can make the picture transparent (Format/Picture) to see text in the
You can also use the Camera Tool to create a linked picture of a cell
and position it on top of the other picture. Set the Fill to No fill,
and the border to No Line.
What I do is to put a text box over the picture and format it with n
lines and no fill...Importing JEs through the Table Import
Is there a way to import JEs throught the table import. If so, how is this
accomplished? Please help! Thank you!
If you have access to table import you must also own integration manager.
either way, yes, you can import transactions. please give me a call at
214-373-8550 and we can walk through the process.
> Is there a way to import JEs throught the table import. If so, how is this
> accomplished? Please help! Thank you!
You can use Table Import but Integration Manager is much, much easier to use.
If you can use Table Import, you own Inte...Outlook Express 6 #51
On April 16, I downloaded Window update. I run Windows 98. I was running
Outlook Express 5. I updated at the time of the Windows update to OE6. Now
when I go to OE I can't open, send any e-mail or open my address book. An
error message comes up that says Msimn This program has performed an
illegal operation....and it closes OE. How do I fix this?
Cathy Wing wrote:
> On April 16, I downloaded Window update. I run Windows 98. I was running
> Outlook Express 5. I updated at the time of the Windows update to OE6. Now
> when I go to OE I can't open, send ...Export to Outlook 2010
I have the new BETA MS/office. All is good except how do I get my Outlook
"07" date into the new BETA Outlook 2010?
You open the previous data file, but then you might mean your data is on one
PC and you want to open it on a new PC?
Not realy enough info
"Jimmy" <Jimmy@discussions.microsoft.com> wrote in message
>I have the new BETA MS/office. All is good except how do I get my Outlook
> "07" date into the new BETA Outlook 2010?
You can connect to an existing pst-file via...Excel power toy for media playlist...
Awhile back there was a power toy that would convert a media play list
so that it could be opened in Excel.
Anyone got a copy or know where I could download a copy?
> Awhile back there was a power toy that would convert a media play list
> so that it could be opened in Excel.
> Anyone got a copy or know where I could download a copy?
Never mind, I found it...the bonus pack!