Jagwarman
asked on
Month format not working
Is there an expert out this that can assist with this please.
I have attached a file wit the date in column 'A'
I want to convert this to mmm-yy in column 'B' so that it will produce a pivot as in the example
I have manually typed the date in column 'C' to demonstarte.
Month.xlsx
I have attached a file wit the date in column 'A'
I want to convert this to mmm-yy in column 'B' so that it will produce a pivot as in the example
I have manually typed the date in column 'C' to demonstarte.
Month.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
=value(A2)