98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Data formating
Data formating
Resolved · Medium Priority · Version 2007
Lorna has attended:
Excel Intermediate course
Excel Advanced course
Data formating
my dates show as 23-sep-1980, i cannot seem to change this format to numbers only.
RE: data formating
Hi Lorna
Thanks for your question
We first need to check if the dates are in fact being entered in a recognisible date format. Can you check to see if they are right or left aligned in the cell, and then please advise me.
If left aligned then they are being formated as text, and this would explain the problem
Thanks
Stephen
RE: data formating
Hi Stephen,
thanks for getting back to me, yes the dates are left aligned always.
I have to import the data from our MIS (SIMS.NET), and i dont think i can change anything!!!
thanks
Lorna
RE: data formating
Hi Lorna
Further to your series of posts, Stephen has notified me of your current requirements. Having discussed this we agree that a solution is available but is beyond the scope of this forum.
I shall email you directly with our proposed action.
kind regards
Jacob
Tue 2 Mar 2010: Automatically marked as resolved.
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Create Equations in Excel 2010Here's how to create basic mathematical |