Hello,
This is really driving me crazy; have tried just about everything I can think of.
Using Excel 2007.
I have some Time data in a column.
It's in GMT, and looks like, e.g., 1430 which would be 2:30 PM
All the manipulation which I want to do with the GMT time drops any leading zeros. I want them to be preserved, of course, as there
must always be 4 digits for GMT to be meaningful.
e.g. 0030 would become just 30. Not good.
Have tried formatting the GMT column as number, general, and text; nothing works.
Doesn't seem to be any GMT format in Special or Custom.
How can I tell Excel to keep all the leading zeros ?
BTW: not to complicate my question any, but the column of GMT data came from a spreadsheet that is not mine.
The column was formatted as a zip code. My guess is that the creator also had problems with leading zeros, and found, possibly,
that this was the only format that allowed
him to show the GMT. My problem is trying to do some manipulation with the column, and some simple math on it, and still have it show the leading zeros.
Some of what I want to do is to merge/append two columns; one with start time, and the other with end time.
I tried using: Cell 1 & " " & Cell 2 as an example, but it also drops the leading zeros when I try this.
I just want to create a third normal size cell column with, e.g., 0030 1200.
I don't want both values in a Larger cell, likes the Merge function seems to do.
Any hints on this specific application would be most appreciated also.
Much thanks, really appreciate the help,
Bob
Bookmarks