| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data appearing as Values
Hello,
I import data in Excel from a software that keeps people punch in-out times. The data appears as times (eg 21:30 or 20:00...) however I cannot change that into a numeric value. Using format option did not help and when try to use a formula the result is an error, "value". Could you please suggest how to import as numbers or change data to numbers? -- Many Thanks. Warmest Regards, |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I suppress values from appearing in a graph? | Excel Discussion (Misc queries) | |||
| values not appearing in autofilter list | Excel Discussion (Misc queries) | |||
| values are appearing automatically in the next column | Excel Discussion (Misc queries) | |||
| summing values appearing in col B when col A has been filtered | Excel Worksheet Functions | |||
| Drop-down data not appearing in exported XML | Excel Discussion (Misc queries) | |||
Threaded Mode
