| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel data in text, wont update to time format
Hello, i have a problem with excel field formatting. The data is in text
format, but i need it to be in time format. When i select a field and select time as formatting then it doesnt updatete the field and i still cant sum the fields. It only updates the field when i select a field, put the cursor at the end of the data and press enter.Then it sums, but when there are millions of fields this isnt rational. How to make excel updatate field formatting. Thank You |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
| Copying Data from Excel to MS Outlook in Plain Text Mode | Excel Worksheet Functions | |||
| analysis of data entered on excel questionnaire format | Excel Worksheet Functions | |||
| Update External Data source from Excel sheet | Excel Discussion (Misc queries) | |||
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Threaded Mode
