| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to now what date represent a serial number?
I'm working with the Workday() fomula, but the number i Received is a serial
number, I would like to change it to a date format |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to now what date represent a serial number?
Try Formatting the cell as date instead of general.
Mike "cubanoluso" wrote: I'm working with the Workday() fomula, but the number i Received is a serial number, I would like to change it to a date format |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to now what date represent a serial number?
thank to you, was really simple.
"Mike H" wrote: Try Formatting the cell as date instead of general. Mike "cubanoluso" wrote: I'm working with the Workday() fomula, but the number i Received is a serial number, I would like to change it to a date format |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to now what date represent a serial number?
Format Cells Number tab select Date OK
"cubanoluso" wrote: I'm working with the Workday() fomula, but the number i Received is a serial number, I would like to change it to a date format |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to now what date represent a serial number?
thank, I already did it was so simple!!!
"Teethless mama" wrote: Format Cells Number tab select Date OK "cubanoluso" wrote: I'm working with the Workday() fomula, but the number i Received is a serial number, I would like to change it to a date format |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| convert serial number into date | Excel Discussion (Misc queries) | |||
| Serial number of Date | Excel Worksheet Functions | |||
| How Do I Eliminate the Serial Number for time from Date? | Excel Discussion (Misc queries) | |||
| date displays as serial number | Excel Discussion (Misc queries) | |||
| How do I convert Date serial number to date | Excel Worksheet Functions | |||
Hybrid Mode
