Custom formatting #7
How can I do the following custom formatting –
I need trailing dots before the number
Thanks for any help
Right Click > Format Cells > Select Custom
Enter "........ "0.00
"John Knoke" <JohnKnoke@discussions.microsoft.com> wrote in message
> How can I do the following custom formatting -
> I need trailing dots before the number
> Thanks for any help
Use a custom number format of *.#,###.00
Note the period between the * and the f...Convert time stored as decimalised number to time format
How can I convert 3.5 hours to 3:30:00?
A1/24 and formate as time
> How can I convert 3.5 hours to 3:30:00?
...Keeping the format but update the data
I have a report I run everyday. I want to update the data, but keep the
column sizes and formatting. Any suggestions? Anybody suggest a good ebook to
become more formuliar with excel?
JoeM, this could be as simple as recording a macro during the formatting of
the sheet after importing the data once. Then each day, after importing the
new data, you simply run that macro.
As for online eBook's for Excel, I'm not actually aware of any although I
suspect a Google search would turn up several. It's hard to beat the "For
Dummies..." series of hardcopy...NEED HELP-wrong formatting saved ??
After using word 2007 and saving a word file, it changed the formatting from
the previous file (i think it was .wps microsoft works word processor) and
now its all messed up.....I think I saved it in some other wrong encoding
standard......now, whenever I open this file now half of it is in some weird
looking unreadable characters....like this
is what seems to happen once the system breaks its laws from the inside.
......couldnt find online solutions...does anyone have any suggestions or
s...Conditional Formating: linking to display another cell
Hello, I am trying to make a traffic light with symbols and I've read to 'use
a separate cell for the dropdown choices, with their resulting value linked
into the formatted cell through an IF function, using the character that you
=IF someone enters '1' in B8, THEN display contents of $C$4 (will it display
font and attributes?)
=IF someone enters '2' in B8, THEN display contents of $C$5
=IF someone enters '3' in B8, THEN display contents of $C$6
But I've been reading everywhere and CF is very new to me and I need ...Newbie Needs Help With Formatting E-Mails
Newbie Needs Help With Formatting E-Mails
I'm new to this site and would appreciate some formatting help.
I created a new Word doc and copied and pasted some graphics and some
simple text boxes in to it. The graphics and text boxes were created
in Powerpoint by someone else. Looks fine on my screen.
Before sending it out via e-mail to an Outlook e-mail group I have, I
first sent myself a test message to see what it would look like on the
receiving end. It looks a mess! The text boxes are all over the
place, as is the text that is not in a box. Also, everything slide
over to ...2003 format in 2007?
I'm used to Outlook 2003, but I just bought a new computer and installed
Outlook 2007. I view a week at a time, and I prefer the calendar format in
2003 -- it shows the whole week in two columns and I didn't have to scroll.
Is there a way I can use the same format in 2007?
No, unfortunately that view had to be removed to enabled calendar overlay.
Try a two week view: http://slipstick.me/2wk
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com/
Outlook Tips by email:
Is the strikethrough formatting option no longer available in Publisher? Or
if you need to use a strikethrough do you have to draw a line through the
text? The line does not always stay in the same spot when you group and then
have to paste on another page.
> Is the strikethrough formatting option no longer available in
> Publisher? Or if you need to use a strikethrough do you have to draw
> a line through the text? The line does not always stay in the same
> spot when you group and then have to paste on another page.
You have the an...Trying to get a type of video file format to open and run on my we
I created a video using Windows Movie maker and saved as .wmp file. I saved
it to my computer and then inserted on my web page under Front Page 2003.
Nothing! I then converted the file to avi format - still nothing! I then
tried mpeg4 still nothing. The manual is next to useless on this subject.
Anyone tell me what I need to do so that when a user opens up the page the
video plays automatically.
Save as a .wmv and insert a suitable player into the page.
For IE only,
Insert->Web Component->Advanced Controls->ActiveX Control
Choose Window...Text formatted email
I am trying to email a long hyperlink path to some one that can only receive
text formatted emails.
When they receive the email it, the hyperlink gets converted in to 2 lines,
top line is a hyperlink (path incomplete) the second line is "text" with the
balance of the hyperlink path.
I placed < > around the hyperlink and it still splits in to 2 lines.
Is there any way to keep the full link path intact?
Tiny URL to the rescue! :-)
Robert Sparnaaij [MVP-Outlook]
Tips of the month:
-What do the Outlook Icons Mean?
-Cr...Import data not in correct format
Import data reads: Need to do statistical anaysis on hundreds of numbers
Cell value # of Cells don't want to enter the numbers by hand.
...Four Conditional Formats?
I am attempting to set up a template for someone else to use on another
machine, and wish conditional format a cell such that it has four
The first is based on an adjacent cell value, and if this is met, then
it is colour 1.
The remaining three, are all AND statements involving the first cell
and another cell value being less than date A, less than date B or less
than date C.
Is this possible to do? I have limited VB knowledge, and am wary of
using add-ins as the people I am sending this to to use have limited
I want to assign a number to a certain conditional format. When the
condition is true it should put a 1 in the cell and when the condition is
false a zero or nothing should be assigned. Anyone? I seem to make the wrong
code all the time.
Use the same test that the CF uses, and return 1 for TRUE and "" for FALSE.
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"Jootje" <Jootje@discussions.microsoft.com> wrote in message
>...my formats get pushed out when I insert columns
I am having trouble when inserting columns in a large data field.
Whenever I insert a column at some point in the data field, th
formulas within the data field adjust, or 'stretch', to accomodate th
added column, however my conditional formatting gets pushed along t
the right and doesn't adapt itself in the same way the formulas do.
This means whenever I insert a column, the formulas remain correct bu
I have to reset the conditional formatting for the entire data field.
I would be extremely grateful for any advice on this situation.
Message pos...Dynamics CRM 4.0
I've modified the format in the system settings screen to be "English
(United Kingdom)", however all dates are still appearing in US
format. Even when you expand the calendar control it displays
incorrectly. Numeric values are correct - showing the pound sign and
correct decimal point.
I've restarted IIS, made sure all SQL logins are British English and
the default regional settings of the server are set to British
English. Even rebooted the server but this still hasn't corrected the
Can anybody tell me how to resolve this please
I was looking ...Custom Formatting numbers question
I have a spreadsheet with lot of millions numbers floating around. When I
make graphs out of it, there's too much zeros.
I don't want to divide all the numbers per 1 million.
Is there a way to custom format those numbers with a mask that would take
care of that problem for me ?
i.e. 7 456 890.98$ would be represented with 7,457 M$
Double-click the numbers on your chart. Hit the Scale tab. From the Display
units drop-down, choose Millions.
"Junkyard Engineer" <firstname.lastname@example.org> wrote in messag...Changing cell format
I have a worksheet that is populated with data exported from Access.
The data in the Access table was serial numbers with an occasional (rare)
The column was formatted "Text" in Access. When I exported it to Excel,
every value in this field (around 3000 entries), has an apostrophe (')
inserted at the frontof the cell. Find and Replace does not see the '
How can I remove this so that I can use Fill>Series to populate the gaps in
my data (there are many gaps)?
Try copying the ' Access character and pasting it into the Replace menu. It
could be...Copying Conditional Format
Is it possible to copy conditional formatting that is already applied
to a given cell to another cell?
I know that the format is held and continuous formatting is possible,
you can copy and paste formatting (including conditional formatting) using
either the format painter (big yellow paintbrush toolbar icon) - click on
the cell with the formatting, click on format painter, click on the cell
where you want the formatting "painted" (double clicking on the format
painter turns it on until you turn it off)
or by using copy and then edit / paste specia...Exponential number format
Operating System: Mac OS X 10.6 (Snow Leopard)
I'm trying to write exponential formulas in excel 2008, but it doesn't recognize the symbol ^ that we use on excel for windows. <br>
Excel Windows : = 2^2 -> result: 4 <br><br>Excel Mac : = 2^2 -> result: error <br><br>When we import some sheet from windows to mac with this formula works, but when I try to create on mac not recognize. <br><br>My question is: There is any other way to use this Symbol, for this kind of formula?
The sam...Change date format in several worksheets
I have about 50 worksheets in a workbook and would like to change the date
format in all. Is there a way to change all at once or must it be done
worksheet by worksheet?
Select first worksheet.
Right-click on the tab and "select all sheets" to group them.
Select data range in activesheet. CRTL + A(twice in XL 2003) will select all
Make your Format changes.
What is done to one sheet will be done to all.
DO NOT FORGET! to right-click on any tab and "ungroup" before making any other
changes unless you want to change all sheets.
Gord Dibben Excel MVP
On Sat...$ Formats
I'm trying to change the format of a cell so that it
reads as "AUD$" rather than just "$".
I have tried the custom formats, but can't get it to work.
Any assistance would be greatly appreciated.
"James" <email@example.com> wrote in message
> Hello again,
> I'm trying to change the format of a cell so that it
> reads as "AUD$" rather than just "$".
> I have tried the custom formats, but...Conditional series... Conditional format
I have results from a two-sided 'game' with more than 5,000 record
collected in 32 distinct runs of the game. Each record includes an X
Y location of an event and reflects the results of a contact betwee
the two sides in which one side or the other is the winner and th
opposing side is the loser. There is a column that indicates whic
side was the winner in each contact (reflected in a single record/row)
With a scatter diagram using the X-Y columns as a series, I can see th
location of the winner in all contacts. Also, I can easily segregat
the results by side with a filter and cho...Format cells #6
I have Excel 2000, Win ME. Recently the pulldown command to format cells
does not always respond - ie, no box appears, so I can't apply borders or
control number format. The shortcut approach doesn't work either. I've
tried Help..Detect and Repair but the fault remains. Any suggestions
...Formatting a single cell
I am trying to enter data, such as name, street address, city, for example
in a single cell, each item to appear on a single line, hopefully indexed
to, again for example, the left.
After formatting the cell to wrap text, you can do this by typing each line
item with a number of spaces between each item. The number of spaces is
just a matter of trial and error. Again, this works, but becomes cumbersome
when you have a larger number of cells. Obviously, the easy (maybe best)
way to do this is just to enter each item in a separate cell, and adjust the
related/adjacent cells accordingl...Problem with custom formats
I have a client that is trying to export an excel
spreadsheet to an Access database The excel spreadshheet
has some custom formats to aid in the speed of data entry.
The problem is this. For Instance:
Cell A1 is formated Custom 5_??"/"32. When you go to that
cell and enter 8 .... 5 8/32 is displayed. However the
actual value in the cell is 8.
When I import this cell into Access I get 8. I actually
need 5 8/32 even if it is a text field. I tried all the
cut and paste and special paste options to no avail. Is
there any way to capture the literals in the format of the