Formatting Time
 

I am having an issue with getting Excel to reformat time. I copy and paste
data from an Access query into a spreadsheet. After doing this, any changes
to the formats on the sheet do not take effect unless I hit F2 and Enter.
These files are rather large, so hitting F2 then Enter is not ideal.

I'm trying to reformat time that is currently 24hour with colon (i.e. 16:00)
to 24 hour without colon (i.e. 1600 or 0500).

Does anyone happen to know why Excel isn't cooperating with me, or anyway to
work around this?

Thank you for your time

Formatting Time
 

F9 will recalculate the sheet in Excel 2000. That may replace the F2
and enter operation.

Formatting Time
 

Sounds like the source data are text numbers

Try this to convert it all at one go to real numbers:
Copy an empty cell, then select the data col, right-click paste special
check "Add" OK
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,500 Files:358 Subscribers:55
xdemechanik
---
"Dan D..." wrote:
I am having an issue with getting Excel to reformat time. I copy and paste
data from an Access query into a spreadsheet. After doing this, any changes
to the formats on the sheet do not take effect unless I hit F2 and Enter.
These files are rather large, so hitting F2 then Enter is not ideal.

I'm trying to reformat time that is currently 24hour with colon (i.e. 16:00)
to 24 hour without colon (i.e. 1600 or 0500).

Does anyone happen to know why Excel isn't cooperating with me, or anyway to
work around this?

Thank you for your time

Formatting Time
 

Just a thought.....1600 is sixteen hundred and is not 16 hours and 00
minutes. Also 1600 is base 10 and 16:00 is base 60. i.e. If you were to
add 00:40 to 16:30 your result will be 17:10, and if you add 0040 to 1600
your result will be 1640. ( I think my math is ok??) :0)

"Dan D..." wrote in message
...
I am having an issue with getting Excel to reformat time. I copy and paste
data from an Access query into a spreadsheet. After doing this, any
changes
to the formats on the sheet do not take effect unless I hit F2 and Enter.
These files are rather large, so hitting F2 then Enter is not ideal.

I'm trying to reformat time that is currently 24hour with colon (i.e.
16:00)
to 24 hour without colon (i.e. 1600 or 0500).

Does anyone happen to know why Excel isn't cooperating with me, or anyway
to
work around this?

Thank you for your time

Formatting Time
 

"Meebers" wrote in message
...
Just a thought.....1600 is sixteen hundred and is not 16 hours and 00
minutes. Also 1600 is base 10 and 16:00 is base 60. i.e. If you were to
add 00:40 to 16:30 your result will be 17:10, and if you add 0040 to 1630
your result will be 1670. ( I think my math is ok??) :0)

corrected my example

"Dan D..." wrote in message
...
I am having an issue with getting Excel to reformat time. I copy and paste
data from an Access query into a spreadsheet. After doing this, any
changes
to the formats on the sheet do not take effect unless I hit F2 and Enter.
These files are rather large, so hitting F2 then Enter is not ideal.

I'm trying to reformat time that is currently 24hour with colon (i.e.
16:00)
to 24 hour without colon (i.e. 1600 or 0500).

Does anyone happen to know why Excel isn't cooperating with me, or anyway
to
work around this?

Thank you for your time

Formatting Time
 

Thanks, very good to know. I don't think it will effect me on this project,
but it might in the future.

"Meebers" wrote:


"Meebers" wrote in message
...
Just a thought.....1600 is sixteen hundred and is not 16 hours and 00
minutes. Also 1600 is base 10 and 16:00 is base 60. i.e. If you were to
add 00:40 to 16:30 your result will be 17:10, and if you add 0040 to 1630
your result will be 1670. ( I think my math is ok??) :0)

corrected my example

"Dan D..." wrote in message
...
I am having an issue with getting Excel to reformat time. I copy and paste
data from an Access query into a spreadsheet. After doing this, any
changes
to the formats on the sheet do not take effect unless I hit F2 and Enter.
These files are rather large, so hitting F2 then Enter is not ideal.

I'm trying to reformat time that is currently 24hour with colon (i.e.
16:00)
to 24 hour without colon (i.e. 1600 or 0500).

Does anyone happen to know why Excel isn't cooperating with me, or anyway
to
work around this?

Thank you for your time

Formatting Time
 

It worked, thanks!

"Max" wrote:

Sounds like the source data are text numbers

Try this to convert it all at one go to real numbers:
Copy an empty cell, then select the data col, right-click paste special
check "Add" OK
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,500 Files:358 Subscribers:55
xdemechanik
---
"Dan D..." wrote:
I am having an issue with getting Excel to reformat time. I copy and paste
data from an Access query into a spreadsheet. After doing this, any changes
to the formats on the sheet do not take effect unless I hit F2 and Enter.
These files are rather large, so hitting F2 then Enter is not ideal.

I'm trying to reformat time that is currently 24hour with colon (i.e. 16:00)
to 24 hour without colon (i.e. 1600 or 0500).

Does anyone happen to know why Excel isn't cooperating with me, or anyway to
work around this?

Thank you for your time

Formatting Time
 

Welcome
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,500 Files:358 Subscribers:55
xdemechanik
---
"Dan D..." wrote in message
...
It worked, thanks!