*.csv Format Saving Problem
New at this.
I have an Excel spreadsheet that I wish to save in .csv format.
It never saves the formatting like Underlines, Bolds, etc., no matter what
This is the first time I've played with .csv
Is there some reason why, with this format, these Bolds and Underlines can't
be saved ?
If so, why, and what else is effected ?
By definition, Comma Separated Value files contain only values, not
In article <aOednUD-bNWQUgDenZ2dnUVZ_sGdnZ2d@comcast.com>,
"Robert11" <firstname.lastname@example.org> wrote:
> New at this.
>...An XML question
I would like to produce the following output based on my XML file:
My Album (2005)
Elapsed Time (hh:mm:ss): 00:07:00
Song 1: title1
Length (hh:mm:ss): 00:02:30
Song 2: title2
Length (hh:mm:ss): 00:02:15
Song 3: title3
Length (hh:mm:ss): 00:02:15
<...Irregular formation of numbers
I hope someone can help, I am trying to format numbers in a column.
the numbers are all 10 digits (ie. 0405613020) and from cell to cel
are all different.
What I am trying to do is for them to take on the format below:
I have tried different things.. but nothing seems to work.. I have ove
250 cells that need to look like that, and it's very long and tedious..
Hope someone can help me..
Message posted from http://www.ExcelForum.com
You can put this formula in a helper column, copy it down as far a
needed and then copy-paste special -...Formating Dates
I need to update a list of dates to show all days as 01. For example, where
date shows 03/28/2009, I need it to read 03/01/2009. I appreciate any
On Thu, 6 May 2010 12:12:01 -0700, LovingLife28
>I need to update a list of dates to show all days as 01. For example, where
>date shows 03/28/2009, I need it to read 03/01/2009. I appreciate any
If you want to convert the dates to the first of the month, then, with your
date in A1:
If you want to leave the date a...So many Tunnel Adapters
I understand that Tunnel Adapter LAN is for
encapsulating IPv6 packets with an IPv4 header
so that they can be sent across an IPv4 network.
Few queries popped up in my mind based on this :-
Why is the numbering for the Tunnel adapter LAN
not sequential ? It is like 6,7,12,13,14,15,16.
A strange numbering scheme ?!
I tried to figure it out by thinking of some arithmetic
series. But, it does not seem to fit in. There is
a huge gap between 7 and 12. Any ideas ?
What is the need for so many number of
Tunnel Adapter LAN connection ? Can you tell me a
scenario that re...Date format on a drop down box
I have a dropdown box that is linked to a cell where a date is put that is
used for other things. The drop down box is filling itself from a range,
which contains a sequential list of dates. I have verified that the dates
are indeed dates and not text values. However, whenever I select a date
using the drop down list, the link cell reverts to a serial format. I have
tried to reformat the cell to be mm/dd/yyyy manually but without any success.
Should be a simple reason but I am stumped here.
You have to format the cell' where you select the date, too. Formatting the
data va...Is there a maximum number of users that can share an Outlook calen
I have 4 users sharing my Outlook calendar, I cannot see how to remove users,
and wondered if there was a maximum as I cannot seem to add more users?
Are you using Delegates or the permissions tab on the properties dialog?
If there is a real limit, its well above 4 - I know of sites where thousands
have permission to view a calendar. There is a practical limit for managing
individual users but this can be worked around by giving permission to
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Cent...Totals on Sales Inquiry native windows
We would like to have the totals on the Sales Inquiries:
Transaction by Customer
Transaction by Document
Today we can retrieve this information in separated inquiries and reports,
be we would like to heve a easier way to see this totals...
The same suggest can be applied to Smartlist. If possible, you can create a
tool to sum a field after you make a filter
I created a screen where you can see all sales, separated by day of week,
and week of year, and totals YTD,MTD and WTD, but I am not able to have the
same information grouped by item number, for example.....Change the assigned chart number
If you use the Macro Recorder and select several charts (in the same
worksheet) in secession you can see that Excel has assigned a name to each
chart such as Chart 1, Chart 2, ect.. Is there a way to rename say Chart 15
to Chart 3, assuming Chart 3 does not already exist?
To manually rename a chart object:
Hold the Ctrl key, and click on the chart to select it
Click in the Name box, to the left of the formula bar
Type a new name, or edit the existing name
Press the Enter key
To programmatically rename a chart object:
ActiveSheet.ChartObjects("Ch...Custom Number Format 04-12-10
I know nothing about using custom number format, and need to undersand when
and how to use it. Any link to recommend?
Thanks in advance.
This Microsoft link expains the concepts fairly well
If this helps, please remember to click yes.
> I know nothing about using custom number format, and need to undersand when
> and how to use it. Any link to recommend?
> Thanks in advance.
...Setting ID# to 1 & Total on bottom of query result
I have 2 separate questions. First how do I set the ID# to 1 for the
first record. I copied my whole database including queries and forms
which were 2009 records and changed the titles to 2010. I did a
"compact and repair" to the 2010 database. But when I start to enter
records for 2010 the ID# is 2550. How can I reset the ID# back to
start at 1?
On many of my queries I have the results be for example 28 Caucation,
43 African American, 65 Hispanic, 4 Asian, 2 Native American. I need
these numbers separate like they are but I would like a total line at
the bottom...Page numbers
I'm using Office 2000 Professional. Is there a way to include page numbers
by default instead of having to insert them every time I create a new
This newsgroup supports Microsoft Access, the relational database.
I'm not sure how to interpret your question...
Microsoft Access MVP
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.
Any code or pseudocode included in this post is offered "as ...total cost on report
I have areport with a cost field that I would like to total that collum at
the end of the report. How do I do this ? do I need to create another field
>I have areport with a cost field that I would like to total that collum at
>the end of the report. How do I do this ? do I need to create another field
The usual way is to use a text box with an expression like:
MVP [MS Access]
I'm in design view of the report, where do I insert this expression?
I clicked on page footer to insert thi...Conditional Formatting more than 3?
Excel 2000 ... Conditional formatting ... an abosolutely
wonderful feature, but why limited to 3 conditions?
Is there a way around this?
I have a Tab Sheet containing 16 monthly Calendars (dates
set by formula) ... These Calendars contain a target date
based on date entered into another cell ... Within the
Calendar I use Conditional Formatting to high-lite:
All dates ... (Format White) ... (Condition 1)
Target date ... (Format Yellow) ... (Condition 2)
Above said ... I have various +/- tollerance windows
around each target date (+/- window is ... 5, 14, 27, & 55
days) ... I have ...Invoice Numbers
First let my apologies. I posted a question earlier but I can't find we're I
I would like to know if there's a way to auto number an invoice before it's
I would think a new table would be required but I'm really not sure how to
setup what's required.
Thank you in advance.
It depends on how far in the past you want to generate the Invoice number
before it is printed AND the steps you go thru to print the Invoice but I
can give you a yes, it can be done. However, more information required to
Gina ...number of OWA certificates
I have published OWA using ISA server. If i want to use SSL bridging then
how many commercial certificates "licenses" I need?
I know logically or technically i can purchase a single server certificate
and install it both on the ISA and OWA server.
So, Do I need to purchase two certificates ?
any help appreciated.
thanks in advance,
I'm not aware of any CA that charges by the number of servers a certificate
is installed on.
Please don't give them any ideas. :-)
"Jack Dorson" <JackDorson@discussions.microsoft.com> wrote in message
I've got a cell that's linked to two other cells which
are percentages, and I want my cell to show each of them
at 3 decimals. Ex. 6.000%/7.125%, where it links to one
cell who's value is 6% and another who's value is 7.125%.
The only way I can do it now it shows UP TO three
decimals, but shortens it if there are zeros. So the
above example would display as 6%/7.125% Any ideas?
Thanks in advance,
=TEXT(A1,"0.000%") & "/" & TEXT(A2,"0.000%")
where A1 and A2 store your two percent values
> I...how can I enter a 21 digit number in a cell & keep it from change
What changes should i make to my set up if I need to be able to enter a
number into a cell that is 20 or more digits long & I want to keep it from
changing to scientific notation (as it does when a number is more than 12
Excel 2003 professional edition
> What changes should i make to my set up if I need to be able to enter
> a number into a cell that is 20 or more digits long & I want to keep
> it from changing to scientific notation (as it does when a number is
> more than 12 digits long)?
> Excel 2003 professional edition
Putti...Too Many Different Cell Format
I got error message " Too Many Different Cell Format". Anyone know what
caused it? Thank you.
for further assistance on this particular issue, click on
learn - n - enjoy
click yes below, if it works for you
> I got error message " Too Many Different Cell Format". Anyone know ...How do I show number of records that meet criteria filter
I have a large spreadsheet containing several hundred rows of data. I want
to filter the list and I want to be able to show the number of records that
match the filter criteria. For example, un-filtered the total number of
records in the list is displayed and, when filtered, the number of records in
the list that match the criteria is displayed.
Can onyone help me please?
Here is a little function that returns the count, and works from VBA. Just
pass the header cell to the function
Function FilteredListCount(rng As Range)
Dim iLastrow As Long
Dim rngTemp ...PDF format pagination
I have several reports utilizing Landscape layout. I followed the Report
Writers Guide from the SDK with the Width at 11 and Height 8.25 or smaller.
However, when I export it to the PDF format, the layout shows up Portrait.
How could I change this? The export is fine in Excel with the correct margin
...Finding Cells that Total a Value
I need some assistance in solving a problem. I have a spreadsheet with
over five hundred lines of transactions. The sum of these transactions
are creating a balance on the account. Is there any formula/macro that
will help me find the transactions creating the balance? The sum of the
account should be zero. To clarify, if we owe client money, there
would be a transaction setting up that postive balance then a payment
on the account taking it back to zero. There could be multiple
transactions and then one net payment. Or we could be due to receive.
So at the end of the day, th...tables and numbering
I have created a six column table in Publisher. The items in each column (or
cell) are numbered items using " bullets/numbers". The first three columns
are listing items by number 1,2,3, etc. However in the last three columns
they are acting like they are linked: first column lists 1,2,3, second
column lists 4, third column lists 5.
Second and third columns should begin with listing "1". The formatting
under the bullets/numbering option seems to be formatted correctly. Any
Do a return, then another return, the next column will revert to one...conditional formatting: multiple conditions with min
I am using Excel 2007 and I am having an issue with conditional
formatting. I have 2 columns of data that I'm working with: Column "c"
which contains both names and some empty cells, and column "i" which
contains dates and some empty cells. If there's a name in column c
then there is definitely a corresponding date in the same row in
column i. However, there are sometimes blank cells in column c dates
that have dates in column i and some rows that have blanks in both c
and i. See the following example:
Sue --- 10/1/2010
___ --- 10/1/2010
Joe --- 10/23/2010
Is there a way to get a total number of items that are about to be tendered,
on the POS screen ?
You can customize the status.htm file. Not sure exactly what the variable is
that you want, but I know it cn be done.
"NJS" <NJS@discussions.microsoft.com> wrote in message
> Hi -
> Is there a way to get a total number of items that are about to be
> on the POS screen ?
Send me your email I have already customized this and will forward you.