Non-US date format in Zoho Sheet
I'm a Zoho user from New Zealand where the standard date format is DD/MM as oppose to MM/DD as is common in the US.
I can set the format for existing dates in Zoho Sheet to DD/MM but still have to enter new dates in the US format. I.e. to enter November 4 I have to put 11/4 even if the cell is set to DD/MM/YYYY and immediately re-displays the input as 04/11/2011.
That's pretty confusing and user unfriendly.
- could the spreadsheet parse the date entered according to the format set for the given cell?
- can we have a global setting for these things somewhere? I want all dates in all Zoho apps displayed by default as DD/MM/YYYY without explicitly setting it everywhere.
That'd be awesome!
Conditional Formatting Enhancements
We have been supporting conditional formatting in Zoho Sheet for more than 11 months now. We support setting rules on Numbers, Text, Data, Cells containing blanks, and errors. We also support setting specific formats based on the result of a Formula. This could be very powerful and could be used to color whole rows based on the value on a particular column. For example, you can define a formula criterion to color alternative rows of a table or to highlight rows if the date in one of the columns falls
One cell, multiple formats, unlimited possibilities.
Spreadsheet formats are more than an aesthetic choice. Proper formatting helps audiences understand your spreadsheet better. Zoho Sheet now allows you to format different parts of your content in cells however you want. What can you do with the new formatting
Publish spreadsheets, sheets, or ranges with specific customizations
Publishing a spreadsheet allows you to share your reports or data with a wider audience. To expand the publishing capabilities for your spreadsheet, we've revamped the publish controls in Zoho Sheet. New look, extensive options With the new publish
Refine by Zia: a smart way to improve data quality
Zia in Zoho Sheet has been helping users with recommended charts, pivot tables, and offering insights about their data. While there is an exclusive smart data cleaning tool, from now on Zia will also include data quality suggestions for error-free analysis,
Webinar: Learn how to instantly clean your spreadsheet data
Hello! Do you find it tedious to get rid of duplicate entries, inconsistencies, and missing values in your data? Join our webinar and learn the trick to clean up your data in an instant. In this session you'll be introduced to the smart data cleaning tool in Zoho Sheet followed by a live demonstration. In this session, you'll get to know: What's new in Zoho Sheet About a smart tool to clean your spreadsheets in an instant How to find and remove duplicate records from your data How to get rid of
Zoho Pagesense Resources
Zoho SalesIQ Resources
Zoho TeamInbox Resources
Zoho DataPrep Resources
Zoho CRM Plus Resources
Zoho Books Resources
Zoho Subscriptions Resources
Zoho Desk Resources
Zoho Projects Resources
Zoho Sprints Resources
Zoho Creator Resources
Zoho WorkDrive Resources
Zoho Campaigns Resources
Zoho CRM Resources
Zoho Show Resources
Get Started. Write Away!
Writer is a powerful online word processor, designed for collaborative work.