Excel doesn't have an autoformat to convert your number into a date.

You have to type it in as a date (including slashes), then the format will
display the date the way you like.

But if want a macro to do the work for you, you could use Chip Pearson's:
http://cpearson.com/excel/DateTimeEntry.htm

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

If you want to read more about these kinds of events:

Chip Pearson's site:
http://www.cpearson.com/excel/events.htm

David McRitchie's site:
http://www.mvps.org/dmcritchie/excel/event.htm

====
And maybe you could use a helper cell that formats the $50.23 the way you like:

=TEXT(A1*100,"0000000")




denileigh wrote:

but I have a couple more questions......I need to auto add the date in a
field like this mmddyy with no slashes.....how do I format that?

Also...the labor field HAS to be 7 characters long so for example
$50.23 needs to be formated as 0005023. Is there a way for have it
figure the amount and format the outcome like that?

Thanks for the help!

--
denileigh
------------------------------------------------------------------------
denileigh's Profile: http://www.excelforum.com/member.php...o&userid=30211
View this thread: http://www.excelforum.com/showthread...hreadid=498927

--

Dave Peterson