| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dates not being recognized as numeric
I'm assisting someone with a workbook and I believe that the source of the
dates is a download from another source. In any case, some of the dates are seen as dates and some are seen as text. Can someone explain what's going on and what we need to do so that its not a problem again. I'm guessing we'll need a short macro to clean up the dates. Thanks, Barb Reinhardt |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Dates not being recognized as numeric
Hi Barb,
I'm guessing we'll need a short macro to clean up the dates. Data, text to columns, fixed width, finish. Regards, Jan Karel Pieterse Excel MVP http://www.jkp-ads.com Member of: Professional Office Developer Association www.proofficedev.com |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Dates not being recognized as numeric
Thanks. We'll try it.
"Jan Karel Pieterse" wrote: Hi Barb, I'm guessing we'll need a short macro to clean up the dates. Data, text to columns, fixed width, finish. Regards, Jan Karel Pieterse Excel MVP http://www.jkp-ads.com Member of: Professional Office Developer Association www.proofficedev.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Blank Value not recognized? | Excel Worksheet Functions | |||
| All columns not being recognized in .csv file. | Excel Discussion (Misc queries) | |||
| ActiveDocument object not recognized | Excel Worksheet Functions | |||
| Command not recognized | Excel Worksheet Functions | |||
| Data isn't being recognized. | Excel Worksheet Functions | |||
Linear Mode
