Logo
Zoho Forums
« Back
You are in : Recent Topics » Zoho Sheet » Sheet Feedback » Importing xls files to Zoho sheets
ariadni

Importing xls files to Zoho sheets
by 
ariadni
 on 11-Nov-2009 10:54 AM.
  in  Zoho Sheet 
» Sheet Feedback
Hi,
I created an INVOICE report in ZOHO CRM, one of the columns is the Invoice date in dd/mm/yyyy format.
I exported this report in .xls format, saved it and then imported it to ZOHO SHEETS.
The problem is with the date field.
It shows as:
'01/07/2008
The apostrophe makes the date unusable, and it can't be removed with the replace command, because it is only visible in the Formula bar, not the actual column data.
Can you help?
Christopher
  • No status
godwin1

Re: Importing xls files to Zoho sheets

by 
godwin1
(Employee)
 on 13-Nov-2009 04:07 AM

Hi,


Yes this is an issue and thanks for raising it to us. We will analyze and get back to you as soon as possible. Thanks

Regards
Godwin


 Back
 Top
Post Actions
Statistics
  • 1
     Replies
  • 134
     Views
  • 0
     Followers
Tags for the post
No tags available for this topic.

Edit Link Delete Link

Edit Link Delete Link

LoadingImage