Posted to microsoft.public.excel.worksheet.functions

Anthony

external usenet poster

Posts: 275

Format problem in displayed userform

Hi all,

In sheet 'DATA' cells B12 and I12 are the source data
these are copy/pasted into cells B2 and I12 of 'RESULTS' sheet
all of these cells are formatted as 'Custom hh:mm' however when I place
these values into my userform they are with no format ie 0.42342423154238

Any ideas as to why??

many thanks

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
Userform problem?	law	Excel Discussion (Misc queries)	0	December 3rd 07 07:54 PM
userform problem	TUNGANA KURMA RAJU	Excel Discussion (Misc queries)	0	August 10th 06 04:43 AM
Userform problem (Listindex)	jgmiddel	Excel Discussion (Misc queries)	1	April 26th 06 01:34 PM
printen userform problem	Pierre via OfficeKB.com	Excel Worksheet Functions	0	January 3rd 06 04:45 PM
UserForm Recall Problem	Andy Tallent	Excel Discussion (Misc queries)	1	April 15th 05 06:14 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us