- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - Microsoft
- >
- Excel formatting
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-18-2004 11:29 PM
04-18-2004 11:29 PM
I have a column with date data.
1) I fail to understand how it's possible tell Excel how to deal with the data and at the same time choose another presentation.
2) Once Excel has screwed the formatting, the damn *ù@#!$£ won't let me get the original data ! I mean, I tryed to change the format, was not satisfy and wanted to put the old way - not with ^Z, I'had made other changes I wanted to keep - but with format "text" or "general".
I don't know if I'm very clear, but this kind of stuff troubles me.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-19-2004 01:53 AM
04-19-2004 01:53 AM
Re: Excel formatting
The structure of a cell of type Date, has various ways of presentation.
If you have modified this format and have made it become first date, after text and subsequently have saved the line with the same name. Then you perhaps don't can more recover the data in the original format.
But
i have understood your question ?
Bruno
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-19-2004 02:02 AM
04-19-2004 02:02 AM
Re: Excel formatting
Now, do you where is what ?
Is it a dd/mm/yy hh24:MM or mm/dd/yy at 08:17 PM ....
I do now what I've put in the column but how Excel will figure out ?
My question is : how do you tell Excel how to interprete the cells content and how do you change the formatting you want to see or print. If both answer are formatting, there something wrong here !
Any idea ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-19-2004 02:29 AM
04-19-2004 02:29 AM
Re: Excel formatting
-Hazem
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-19-2004 02:35 AM
04-19-2004 02:35 AM
SolutionExcel formats the dates based on your settings in the "regional and language options" (Control Panel -> Regional and language options)
Take the same example
Regional setting is
-------------------
Short Date - 4/19/2004
Time - 10:30:08 AM
Then Excel formats this date 01/04/04 08:17
as dd/mm/yyyy hh24:mm
it will be 01/04/2004 08:17 AM
If u want it in a different way by Default then u have to change the regional settings.
Hope i understood your question.
Ganesh
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-19-2004 02:58 AM
04-19-2004 02:58 AM
Re: Excel formatting
Start -> Settings -> ControlPanel -> International-Settings (choose Date, Time, Number, etc.)
HTH
Bruno
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-19-2004 12:20 PM
04-19-2004 12:20 PM
Re: Excel formatting
My personal quote : Excel sucks !