| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Leading Zeroes
Hi, I hope you are having a great day.
I have an 6 character field containing mmddyy values (for example, 100587, 60276). Problem is when month is 1 - 9, I need the contents to be zero filled so as the 60276 looks like 060276. Can someone explain what I need to get that accomplished? Thanks in advance. KenP |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to keep leading zeroes when saving in xls in csv format | Excel Discussion (Misc queries) | |||
| No decimals and leading zeroes | Excel Discussion (Misc queries) | |||
| CSV leading zeroes | Excel Discussion (Misc queries) | |||
| How do I format data cells in Excel to keep leading zeroes? | Setting up and Configuration of Excel | |||
| single quote 10-digit number that has leading zeroes & then conca. | Excel Worksheet Functions | |||
Threaded Mode
