I have split apart date and time and need to add leading zeros so when I
concenate(SP) that it will add correctly.
I need real detailed instructions as I am a newby.
Thanks

If you want to create one cell showing date and time from a date in A1
and time in B1 you can just add the 2, i.e.

=A1+B1

use

CellsFormatNumberCustom and format as desired e.g.

m/d/yy hh:mm AM/PM


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=522369

You shouldn't need to have "leading zero's"
Example
Cell A1 23
Cell A2 23000
Cell A3 23023
If you want to "SPLIT" your data and you need "leading zero's" to be
able to align your text correctly - change your column to 'TEXT' and
then you can add leading zero's - otherwise EXCEL will delete them.
What you might try also to "align" your text to be able to split it is
- Select your Column and then "RIGHT JUSTIFY" the TEXT - The right
justify is on the MENU BAR as an icon. Be sure you also use the COURIER
FONT - then you can see how things "really" line-up.


--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: http://www.excelforum.com/member.php...o&userid=29640
View this thread: http://www.excelforum.com/showthread...hreadid=522368