Posted to microsoft.public.excel.programming

Mick Southam Mick Southam is offline

external usenet poster

Posts: 17

Time formatting

Hi

Does anyone have a method for entering any number, say, 0800 and it will
automatically insert a colon in between the 08 and 00. I have a method of
automatically changing data entered in lower case to upper case, but cannot
work this one out - Can you?

--
Kind Regards

Mick

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
Time formatting	MD	Excel Worksheet Functions	3	June 28th 07 11:49 PM
Time formatting	Eileen	New Users to Excel	2	October 3rd 05 09:34 PM
Time formatting	dziw	Excel Discussion (Misc queries)	2	September 15th 05 01:30 PM
time formatting and time categorizing (vlookup or data validation)	MarianneR	Excel Worksheet Functions	4	November 18th 04 03:24 PM
time formatting and time categorizing (vlookup or data validation)	MarianneR	Excel Worksheet Functions	0	November 18th 04 03:13 PM

All times are GMT +1. The time now is 05:37 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us