How do I insert leading zeros?

[goldilocks]

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

 

[daddylonglegs]

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

Cells>Format>Number>Custom and format as desired e.g.

m/d/yy hh:mm AM/PM

 

[wjohnson]

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 b
able to align your text correctly - change your column to 'TEXT' an
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 i
- Select your Column and then "RIGHT JUSTIFY" the TEXT - The righ
justify is on the MENU BAR as an icon. Be sure you also use the COURIE
FONT - then you can see how things "really" line-up