We have added search box. Key in SAP issue keyword to search
Home
About
Site Archive
SAP Chat
Contact
TopBottom

Announcement: wanna exchange links? contact me at sapchatroom@gmail.com.

Re: [sap-acct] Sorting by date after uploading to excel

Posted by Admin at
Share this post:
 Ma.gnolia DiggIt! Del.icio.us Yahoo Furl Technorati Reddit

0 Comments

Posted by Suryam SL
on Jul 18 at 12:14 PM 		Mark this reply as helpfulMark as helpful
Dear Mr. Hyder Ali
You can "convert" the date field into DD MM YY or MM DD YY format in Excel
For this the navigation is:
High light the date column
Please clck on "Data" (or ALT-D)
Click on "Text to Columns"
Click on Fixed Width
Click next
Click next (In other words, twice the Next is to be selected)
Click on Radio Button Date and select the format D M Y
Click finish
The downloaded data from FBL3n gets converted into date format
Then, you can sort this data

Regards
Suri



On Sun, Jul 18, 2010 at 8:22 PM, HAIDER ALI via sap-acct <
sap-acct@groups.ittoolbox.com> wrote:

> Posted by HAIDER ALI
> on Jul 18 at 10:48 AM I face problem with date sorting of data I
> uploaded to excel from FBL3N or from other transations. Any body can advise
> me on that.
>
> Thanks and regards
>
> Haider

__.____._
Copyright © 2010 Toolbox.com and message author.

Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
_.____.__

 

0 comments:

Post a Comment

Post a Comment

Subscribe to: Post Comments (Atom)

T r a n s l a t e to your language