|
|
|
|
1 |
242 |
|
|
How to display a date by
Barry
I would like to display a date time in the format of:
20100331213045 etc..
the 2010 being the year
the 03 being the month
the 31 being the day
213045 being...
|
|
1 |
282 |
|
|
|
March 31st, 2010 03:48 AM
by Barry
|
0 |
235 |
|
|
Display the date in an unusual format by
Barry
I'm using Excel 2003 Sp3
I'd like to display the date entered in cell H3 in cell I3 in the following
format:
20100331215045
2010 year
03 month
31 day
|
March 31st, 2010 03:46 AM
by Barry
|
0 |
217 |
|
|
|
March 31st, 2010 03:31 AM
by Tonso
|
3 |
263 |
|
|
|
|
1 |
253 |
|
|
|
|
2 |
236 |
|
|
|
|
2 |
315 |
|
|
|
|
16 |
523 |
|
|
If Statement Nesting? by
ThunderBlade
Can You Nest an If Statment so that the Logic has to check 2 different cells
before it outputs the True/False date?
|
|
4 |
228 |
|
|
[INDIRECT] Syntax Help by
ThunderBlade
OK MAX,
Hope this reply is correct enough.
And if you would have read what I stated carefully, It didn't seem to work.
I did use your suggestion of doing the...
|
|
2 |
197 |
|
|
|
March 30th, 2010 09:53 PM
by Dana
|
0 |
200 |
|
|
Cannot open spreadsheet by
User
I cannot open a spreadsheet from an e-mail attachment, from a hyperlink or
from Windows Explorer. Excel opens and the blue screen indicates "ready" but
the...
|
March 30th, 2010 09:46 PM
by Reeza
|
2 |
243 |
|
|
|
March 30th, 2010 09:03 PM
by Jeannie
|
0 |
211 |
|
|
Date format by
Emece
I have a column with dates in the following format: 30/03/2010 (Spanish date
format) I want to display in another column only the month, and in format
dddd,...
|
|
9 |
220 |
|
|
Linking Formula by
Don S
I have a workbook with multiple data sheets. Each data sheet has a sum total
in cell B4. I created a summary sheet to pull all the totals into it. I
entered...
|
|
2 |
223 |
|
|
|
March 30th, 2010 08:30 PM
by Marcelo
|
1 |
214 |
|
|
Windows 7 Excel 7 by
Genesis
Over the last week while in a spreadsheet, excel has just arbitrarily begun
to restore/repair a file. This has happened a couple times, no power
failures or...
|
March 30th, 2010 08:30 PM
by Genesis
|
0 |
175 |
|
|
If formula with dates by
murkaboris
Hello:
I need a formula that can look at column "A" and calculate the number of
days from today --- could be either before today or in the future and if it...
|
|
4 |
205 |
|
|
|
|
3 |
288 |