Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time Conversion in Spreadsheet
I am downloading a file from our company's database. It is no problem
formatting the standard military time to "regular" time, but I have to double-click each cell to make the change. This takes an inordinate amount of time because of the number of cells. Any way to make this go faster. Thanks in advance! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time Conversion in Spreadsheet
"Deb" wrote: I am downloading a file from our company's database. It is no problem formatting the standard military time to "regular" time, but I have to double-click each cell to make the change. This takes an inordinate amount of time because of the number of cells. Any way to make this go faster. Thanks in advance! how about double clicking the first cell then using format painter to copy the format down the full column |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time Conversion in Spreadsheet
Hi Deb,
I assume you have the time to be converted in one column so highlight the column right click in the mouse and then apply your format If this helps please click yes, thanks "Deb" wrote: I am downloading a file from our company's database. It is no problem formatting the standard military time to "regular" time, but I have to double-click each cell to make the change. This takes an inordinate amount of time because of the number of cells. Any way to make this go faster. Thanks in advance! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time Conversion in Spreadsheet
Try the below and format the cell to time format..
=--TEXT(A1,"00\:00") If this post helps click Yes --------------- Jacob Skaria "Deb" wrote: I am downloading a file from our company's database. It is no problem formatting the standard military time to "regular" time, but I have to double-click each cell to make the change. This takes an inordinate amount of time because of the number of cells. Any way to make this go faster. Thanks in advance! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
lotus 2.4 spreadsheet conversion | Excel Discussion (Misc queries) | |||
Conversion of Forms into spreadsheet row wise | Excel Discussion (Misc queries) | |||
Time conversion | Excel Worksheet Functions | |||
Spreadsheet conversion | Excel Discussion (Misc queries) | |||
conversion of MS Works Spreadsheet to Excel 2002 Spreadsheet | Excel Discussion (Misc queries) |