ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   how to now what date represent a serial number? (https://www.excelbanter.com/excel-worksheet-functions/140381-how-now-what-date-represent-serial-number.html)

cubanoluso

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

Mike H

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


Teethless mama

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


cubanoluso

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


cubanoluso

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



All times are GMT +1. The time now is 03:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com