Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Converting all leading zeros
Because of a backlog with our .NET programmer, I am working with a
report that was extracted from an SQL database to an Excel file. I have linked the Excel file to Access to provide reports in a specific format so that all I have to do is run the extract then overwrite the existing XLS extract. However, I have noticed that there are sometimes leading zeros in some of the entries which could be either in the month and/or the day. Even worse, some years are only two digits. I need the format to be m/d/yyyy (only 1/1/2009 - not 01/01/09 or any variation thereof) for my calculation in the report to work. The extract has over a dozen columns with dates I will need to validate. Any ideas or links so that I can apply to format properly appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Display leading zeros in numeric value without converting to text | Excel Discussion (Misc queries) | |||
Leading Zeros | Excel Discussion (Misc queries) | |||
add leading zeros | Excel Worksheet Functions | |||
save text field w/ leading zeros in .csv format & not lose zeros? | Excel Discussion (Misc queries) | |||
Leading zeros | Excel Discussion (Misc queries) |