LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default from date format convert to text format is wrong

Hello All,

I download from SAP to excel a database. But unfortunately I can't convert
date cells to text. For Example: 2010.02.01 and if I convert to text format
i'll get 40181 data all cells.
I have tried to copy my worksheet to other worksheet with copy paste special
only values, but the result is same.

Please help!

Regards,
Nooris
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Convert Text to Date format Fellow Wanderer Excel Discussion (Misc queries) 3 October 4th 07 08:49 PM
Convert date from text format to date format Anita Excel Discussion (Misc queries) 3 June 4th 07 11:57 AM
Convert date + time text format to date format Paul Ho Excel Worksheet Functions 2 May 22nd 07 05:47 PM
How to convert text into date format? Eric Excel Discussion (Misc queries) 6 January 24th 07 03:27 PM
How to convert text into date format? Eric Excel Worksheet Functions 4 January 24th 07 02:37 PM


All times are GMT +1. The time now is 07:07 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright 2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"