Menu

need help with a If=then situation.

Search this Thread

Prev

Previous Post

Next Post

Next

#4

Report Post

Posted to microsoft.public.excel.programming

Franz

Franz is offline

external usenet poster

Posts: 10

Default

need help with a If=then situation.

"FireBrick" ha scritto nel messaggio

I have a little Excel file to use transcribing some old paper data

The field is a 4 digit number representing a 24 hour moment
0522 would be 5:22 am.
all I want to enter is they 4 digit number

Many entries would be the same, as the entries all happened in the
same minute
so what I'd like to do, is...
If I leave the field blank, it would fill itself with the time put
into the field above it.
All the fields in the column are 4 digit

I think this should work:
1) menu Edit = Go to = Special... select the option Blank cells and then
OK
2) digit = and then with the up arrow select the cell above the first blank
cell;
3) press ctrl+enter;
4) select the column with you filled in this way and then select Edit =
copy and after Edit = copy/paste Special Values.

--
Hoping to be helpful...

Regards

Franz

----------------------------------------------------------------------------------------
To reply translate from italian InVento (no capital letters)
----------------------------------------------------------------------------------------

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
What Should I do in this situation	Dave[_11_]	New Users to Excel	5	August 20th 09 06:07 PM
Strange situation	rexmann	Excel Discussion (Misc queries)	0	May 4th 07 10:59 AM
Can queries be used in this situation?	MLK	Excel Discussion (Misc queries)	0	January 11th 07 02:15 PM
Nested IF in this situation	Cossminnn	Excel Worksheet Functions	6	May 20th 06 11:45 AM
Best function for my situation	phil si	Excel Worksheet Functions	1	November 16th 04 10:49 AM

All times are GMT +1. The time now is 01:35 AM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement