cell format #16
I set up cell format as text before I type any data.
I have a samples with ID 9920-2, 9920-10, 9920-15, 9920-18,...
However if I push "Enter" after typing ID, Excel change 9920-2 and 9920-10
to Feb-20 and Oct-20 without even ask do I wnat to change format. ID after
9920-15 remain the same.
Can anyone tell me how to make Excel stop changing my format, and just keep
the format I have set up.
Enter with leading apostrophe which won't show.
"Terry" <Terry@discussions.microsoft.com> wrote in message
news:56720157-F348-46F6-91E7-684C8691CC13@m...How to format cell with text and date.
We are trying to set up a custom format for a column of cells that contain a
letter, a hyphen, and a date. The letter is variable; it can change from one
row to another (e.g., L-09/28/05, A-09/29/05, etc.). Is it possible to
create a custom format for something like this?
Thanks for your help and advice.
Since your prefix can change from one row to another, I think you will need
to use a TEXT Worksheet Function instead of a custom cell format.
F2: =LEFT(E2,1) & "-" & Text(A2,"mm/dd/yy)
If you have a choice I would really suggest a more readab...how to format :send picture with message: as a default
each time i sent a graphic i must go to the format and click "send picture
with message." how do I make this a default so it is there permanently.I am
running on a Windows XP and am using Outlook Express for my mail.
LYNNY <LYNNY@discussions.microsoft.com> wrote:
> each time i sent a graphic i must go to the format and click "send
> picture with message." how do I make this a default so it is there
> permanently.I am running on a Windows XP and am using Outlook Express
> for my mail.
Ask in an Outlook Express newsgroup.
...Custom format a text cell with square brackets: [ ] ?
Is it possible to format a text cell so that the user can just type in
a text reference from a catalogue - i.e., letters of the alphabet -
but that Excel then puts in square brackets?
i.e., rather than typing in [A1], the user types in A1 and Excel shows
the cell contents as [A1}.
Select the cells in which you want the brackets
On the Number tab, choose Custom
In the text box, type: "["@"]"
> Is it possible to format a text cell so that the user can just type in
> a text reference from a catalogue - i...Format error
I am trying to open a copy of my database that has been
saved onto CD using Nero Backup program. On opening I get
an error message saying the file is in an unknown format
although it looks fine, this doesn't happen with other
file types. Any suggestions?
Not sure this is your problem, but you might want to give it a shot:
Upon opening a file, Access creates a temporary lock file (filename.ldb) in
the same directory where the file is opened from; in the case of a CD, the
system is obviously unable to write to the medium. If indeed, this is all
there is to it, and the error mess...Format date with specific regional format
I am working in a international group where users have different regional
settings: UK, Denmark, Turkey. I want dates to always show in UK format, even
when regional setting is another country. I need this to work in:
1) ordinary cell format
2) using TEXT() function to construct text expressions using dates.
In Excel 2003, I remember it was possible to insert a regional code number
in brackets into a custom cell format. Is this possible in Excel 2007? Would
this work in the TEXT() function?
In the format code, try prefixing the UK code [$-809] to the date format.
http:...Publisher File formats
I need to send file in a tif or jpeg format but when I
save the file I still get the pub extension after the .tif'
Can I not save in anything but pub?
It would help us to answer your question if you told us which version of
Publisher you are using.
Two things are aesthetically perfect in the world - the clock and the cat.
"Ray" <email@example.com> wrote in message
> I need to send file in a tif or jpeg format but when I
> save the f...filtering for certain formatted data
How can use the advanced filter to filter information with a certain format?
You'd have to write your own procedure to do this kind of thing.
Ron de Bruin has some filtering based on format in his easyfilter addin:
> How can use the advanced filter to filter information with a certain format?
Is there any way to save an excel 2007 spreadsheet with the
corresponding pivot tables and have the pivot tables work that they should
for an excel 2003 user?
Basically how can you save a excel 2003 pivot table in a format in a a
excel pivot table user? How do you save a excel 2007 pivot table in a 2003
excel pivot table
...Formats for video
What are the formats most commonly used for posting video to a personal
website? I want to post some holiday video, but would like to maximise the
chance that users will be able to view the video without having to download
additional software, and without taking too much time or bandwidth.
Can you help?
Heidi <Heidi@discussions.microsoft.com> was very recently heard to
> What are the formats most commonly used for posting video to a
> personal website? I want to post some holiday video, but would like
> to maximise the chance that users will be able to ...change view format of selected cell
Is there any way to change the way the cell is viewed when selected?
Right now it makes a big black box around it, and it clashes with the
lines I already have in the spreadsheet.
And can this fomatting be saved into the document so others will see it
hopeace's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=28009
View this thread: http://www.excelforum.com/showthread.php?threadid=476056
you may want to try Chip Pearson's Rowliner:
htt...merge: data losing formatting
I am merging from an Excel spreadsheet. Two of the three fields that contain
numbers formatted as currency are losing their formatting in the merge. All
three are formatted the same in the data source. Please help!
While in a state of ecstasy after repairing his laptop, Ed sees a
message from cheekymama <firstname.lastname@example.org>. On it
> I am merging from an Excel spreadsheet. Two of the three fields that
> contain numbers formatted as currency are losing their formatting in
> the merge. All three are formatted the same in the data source.
Try export...How do you link formatting between worksheets
...Formatting the result of a VLookup / Custom Formatting
I am having difficulty formatting a cell which contains both text and a
I have an example of the cell below:
="Here lies the text before Vlookup "
&VLOOKUP($M$20,sheet1!$B$10:$L$1445,8,FALSE)&" Here lies follow-up
The VLookup should return a date but instead is returning a string of
numbers. I'm sure there is a way of setting the format within the
formulae using dd/mm/yy somewhere. Could anyone tell me how to do this?
Kind regard...HELP! Need to save in Excel 2.1 format
I have excel 2007, and the datasystem here only accepts excel 2.1 format
How can i convert or save in excel 2.1 format?
I'd really appreciate any input, even link to some external convert program.
Why you don't try to save it as excel 5.0 It should work
when saving as scroll almost to the bottom there you will find excel 5.0
> I have excel 2007, and the datasystem here only accepts excel 2.1 format
> How can i convert or save in excel 2.1 format?
> I'd really appreciate any input,...More than 3 on Conditional Formatting
Can it be done?
I don't want to have to write a routine in VBA to scan all the cells just to
change the colour.....
i.e. 1 is red 2 is a lighted red, 3 is amber 4 is a ligther amber, and 5
green and 6 a lighter green...
I need some help here guys...
Anyone point me in the right directions...
modify one of these. The first one belongs in the SHEET code module.
right click on the sheet tab>view code>insert this>save
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column <> 1 Then Exit Sub
Select Case UCase(Target)
Case "...Best format for formatting financial ratios
I need to create financial ratio's for a university assignment but also
analyse them as i go along so i'm assuming word would be the best part of the
office suite to use. However, i'm not sure how i should format them to make
them look proffesional showing the workings too.
Thanks in advance
When you've decided how you want your ratios and formulas to look, we
can help you make them look that way, but we can't deal with the
content of your work.
On Jan 19, 8:43=A0am, jtrobinson <jtrobin...@discussions.microsoft.com>
> I need to crea...Format
I have a spreadsheet listing some items with dates and these Items need
to be updated every 5 years, but I need to know when they are due 60
I was given the following format, but this seems to take off 60 days
(off the present date).
The Date in say B4 shows the day the item was "issued" in C4 it should
tell me 60 days before it is due to be renewed. i.e. 5ive years minus 60
The formula I was given looks like this:
B4 being the issue date
TODAY = present date
AS I have n...formatting the TOC
I have a heading which is spread into almost two lines. But when i generate
the TOC, it displays the heading in a single line.
Please suggest me a solution.
Thanking in anticipation.
Are you saying that you want your TOC to use the same font as size as your
>I have a heading which is spread into almost two lines. But when i generate
>the TOC, it displays the heading in a single line.
>Please suggest me a solution.
>Thanking in anticipation.
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/...Conditional Formating Based on Date #2
I need some help on conditional formating. What I want to do is change the
color of a cell based on the date, i.e. if the date in the cell is today or
greater I want the cell color to change to red, if the date is 3 days before
the date in the cell I want it to change color to yellow.
condition 1 formula is
cond 2 etc
"Roy" <Roy@discussions.microsoft.com> wrote in message
> I need some help on conditional formating. What I wa...Custom Number format #2
What custom number format to use so that
1.5 will display as 1.5
1 will display as 1 not 1.0 or 1.
Any help will be highly appreciated
In article <uri1#$nAEHA.2036@TK2MSFTNGP12.phx.gbl>,
"JON JON" <conrado_capistranoREMOVE@msn.com> wrote:
> Hello, NG
> What custom number format to use so that
> 1.5 will display as 1.5
> 1 will display as 1 not 1.0 or 1.
> Any help will be highly appreciated
Based on your examp...Excel date formatting
Operating System: Mac OS X 10.5 (Leopard)
I have formatted the cells to yield a date in the form 14-Mar. If I input 3/4 or 3-4 the cell yields 4-Mar. It will not allow me to enter the data in the same format I want it the data output. If I enter 30/11 I expect to get 30-Nov, but I do not. It seems logical to me that I should be able to input the date in the same format as I want it output. Can this be done?
It's a matter of your System Preferences settings - Excel takes its cue from
that. Change your International preference for Formats & Excel wi...sort/format this spreadsheet
hi, following the failure of my last post....hoping somebody here can
help me with this.
i have a spreadsheet that looks something like this (except with about
10 000 rows)
DOT1 AGENT1 NAME1A
DOT1 AGENT1 NAME1B
DOT1 AGENT1 NAME1C
DOT1 AGENT1 NAME1D
CLPM AGENT2 NAME2A
CLPM AGENT2 NAME2B
U788 AGENT3 NAME3A ...Time format
Hi I would be grateful for help with time format in excel 2003. I want to
show the time without seconds showing. At the moment the only choices I have
I have changed the settings in control panel
Assuming these are properly formatted times simply apply a Custom format of
to the cell(s)
Note that formats only change what you see on the sheet, the underlying
value remains the same.
To apply the format, select the cell(s) and right click and select 'format
cells' select 'custom' and rn...Output data to file in Fortran 6F10.3 format
I'm a new to writing Excel macros and have hit a bit of a wall.
I'm using Excel to pre-process data for an old Fortran Application. I
requires a .dat file containing a preamble and then data in a 6F10.
The Excel data I want to write to the file is formatted as Number wit
3 decimals (+ or -). I have a macro that creates the file and preamble
I can read all the data, but I'm having trouble getting the 6 column
of F10.3 to format properly. The blank spaces are 'space' (Chr32). Th
negative sign is left of the most significant figure, not to the lef
of the field.