ExcelBanter - Excel

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Excel (https://www.excelbanter.com/excel-discussion-misc-queries/62892-excel.html)

Vincenzo

Excel

Can somebody please help. I'm getting incosistent formula errors for some
date values but not for all. All date values use the same formula.

Here's my formula:
=TEXT("2005-02-02 11:57:45.73","d-mmm-yyyy hh:mm:ss")

exceluserforeman

Excel

=TEXT("2005-02-02 11:57:45.73","d-mmm-yyyy hh:mm:ss")
It works for me

"Vincenzo" wrote:

Can somebody please help. I'm getting incosistent formula errors for some
date values but not for all. All date values use the same formula.

Here's my formula:
=TEXT("2005-02-02 11:57:45.73","d-mmm-yyyy hh:mm:ss")

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