Hello All,

I've got a multi page which contains several chkboxs on. When a use
clicks the submit button, the code will loop through the check box's
find out which ones have been checked and then populate a range wit
the caption of the checked box's.

Works greated, except for when it comes to a certain set of captions
All of the captions are in the form of 03A01, 03B02, etc.

However when it get's to 03E01 & 03E02 it the populated cells rea
3.00E+01 (& 02 respectivly). When I look at the "format cell" on th
actual worksheet it lists it as "scientific" instead of general as th
rest are. I've tried changing the formating back to general but when
run the form it changes back again.

Is "03E" a reserved notation or something?

It works fine with 03F, etc. just 03E doesn't work.

Sorry for the long post, just trying to give as much info. a
possible.

Thanks

--
Message posted from http://www.ExcelForum.com