Date Formatting
 

Tommy,

These rogue dates that won't format may be text that look like dates. If we
have one of these in A1 try this formula

=isnumber(a1)

which should evaluate as TRUE. If it evaluates as false then it's text.

The fix depends on what is actually in the cell but you could try putting a
1 in an empty cell and copying it then select these 'dates' paste special -
multiply - OK
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Tommy" wrote:

I receive data everyday with the dates in the following format - 1/12/2025
(dd/mm/year), however I'm trying to format it to the following format-
01-Dec-25.

The option is available under formatting, but the majority of the dates in
the column I select don't format properly. I can't figure why this happens...

Can anyone offer a suggestion as to how to format so the entire column
formats?

Date Formatting
 

Mike-

Thanks for the help! =isnumber(a1), showed some cells coming up as false...

Is there any way to format or correct the "false", so that the dates fields
can be formatted in the way I would like? Multipling them by 1, left some
cells comng up with 1 as the resulting value. Any help would be appreciated.

Thanks,

Tommy


"Mike H" wrote:

Tommy,

These rogue dates that won't format may be text that look like dates. If we
have one of these in A1 try this formula

=isnumber(a1)

which should evaluate as TRUE. If it evaluates as false then it's text.

The fix depends on what is actually in the cell but you could try putting a
1 in an empty cell and copying it then select these 'dates' paste special -
multiply - OK
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Tommy" wrote:

I receive data everyday with the dates in the following format - 1/12/2025
(dd/mm/year), however I'm trying to format it to the following format-
01-Dec-25.

The option is available under formatting, but the majority of the dates in
the column I select don't format properly. I can't figure why this happens...

Can anyone offer a suggestion as to how to format so the entire column
formats?