Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell format will not update
Hi
I keep running across the same problem with a large project and it's driving me crazy. I have a worksheet with data already provided in this format: dd/mm/yyyy hh:mm:ss To be worked with, it needs to be transferred into this format: yyyy/mm/dd hh:mm:ss I set up a custom format to perform the required change, the trouble is that even though the selected list of data has had the cell format applied using format painter, it does not automatically update the data. Saving, closing and reopening does not perform the format change either, nor does ctrl F9. The only thing that works is to click into each cell and hit enter. Hey presto, it updates. Is there any other way of forcing the format change? I have some extremely large chunks of data to work through. Thanks! Joll |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell format will not update
Hi jOLL,
If data is already avl then you can use following formula =TEXT(A1,"yyyy/mm/dd hh:mm") H S Shastri "Joll" wrote: Hi I keep running across the same problem with a large project and it's driving me crazy. I have a worksheet with data already provided in this format: dd/mm/yyyy hh:mm:ss To be worked with, it needs to be transferred into this format: yyyy/mm/dd hh:mm:ss I set up a custom format to perform the required change, the trouble is that even though the selected list of data has had the cell format applied using format painter, it does not automatically update the data. Saving, closing and reopening does not perform the format change either, nor does ctrl F9. The only thing that works is to click into each cell and hit enter. Hey presto, it updates. Is there any other way of forcing the format change? I have some extremely large chunks of data to work through. Thanks! Joll |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Validation lists update orginal cell with list update | Excel Worksheet Functions | |||
HOW CAN I FORMAT COLUM B TO UPDATE DAYS DELIQUENT DAILY | Excel Worksheet Functions | |||
auto-hide rows, cell format (# and @), update cell refs, shade cel | Excel Discussion (Misc queries) | |||
Update a part of format to external workbook | Excel Worksheet Functions | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions |