How to format data to the given format

date format not changing in excel
how do i change the date format in excel to dd-mmm-yyyy
how to change date format in excel to dd/mm/yyyy
how to change default date format in excel
excel not recognizing date format
how to change date format in excel mac
what is long date format in excel
how to change date format in excel to dd/mm/yyyy using formula

Currently I am passing Json data as

coords: [
  {lat: 27.17841526682381, lng: 73.29395468749999}, 
  {lat: 24.88842099751237, lng: 73.64551718749999}

Instead of this, I need to send Json data as

 coords: [
    {27.17841526682381, 73.29395468749999},
    {24.88842099751237, 73.64551718749999}]

How can I able to achieve the same. How can I obtain these result.

All you need is a very simple map() operation

const coords = [
  {lat: 27.17841526682381, lng: 73.29395468749999}, 
  {lat: 24.88842099751237, lng: 73.64551718749999}

const res = => [, o.lng])


Formatting Data, If you don't like the default date format, you can pick a different one in Excel, like February 2, 2012 or 2/2/12. You can also create your own custom format in  If you omit the /v command-line option or use it without specifying a volume label, format prompts you for the volume label after the formatting is complete. Use the syntax /v: to prevent the prompt for a volume label. If you use a single format command to format more than one disk, all of the disks will be given the same volume label.

The easiest way is to use Array#map() with Object.values() as a callback:

coords =;


Note that your desired output format is incorrect because the inner objects aren't valid objects, they should be arrays.


let coords = [
  {lat: 27.17841526682381, lng: 73.29395468749999}, 
  {lat: 24.88842099751237, lng: 73.64551718749999}

coords =;

Format a date the way you want, Format numbers as text for numbers larger than 16 digits, credit card numbers or when you import or copy numbers from a database or other data source. also use the TEXT function to convert a number to text in a specific number format. I want to get the format of a given date string. Example: I have a string like 2011-09-27T07:04:21.97-05:00 and the date format of this string is yyyy-MM-dd'T'HH:mm:ss.SSS.

Try this.... use Object.values()

var coords= [
  {lat: 27.17841526682381, lng: 73.29395468749999}, 
  {lat: 24.88842099751237, lng: 73.64551718749999}

let items = [];
for (var prop in coords) {

 var val= Object.values(coords[prop]);
<script src=""></script>

Format numbers as text - Excel - Office support, Along with numbers, dates and times are the most common data Use the Format Cells dialog to get the number behind a given date in Excel. XML is a widely used format for data exchange because it gives good opportunities to keep the structure in the data and the way files are built on, and allows developers to write parts of the documentation in with the data without interfering with the reading of them.

Assuming that your output should be a nested array like:


You can use reduce on your array of objects to achieve this in the following way:

var coords = [
  {lat: 27.17841526682381, lng: 73.29395468749999}, 
  {lat: 24.88842099751237, lng: 73.64551718749999}

var formattedCoords = coords.reduce((dict, item) => [...dict, [, item.lng]], []);


How to change Excel date format and create custom formatting, Formatting Numbers​​ In the AutoTag tab on the ribbon select the "Format Data" button to open the Format Data interface. In the "Category:" list select "Number." Set the desired "Decimal places:." In the "Negative numbers:" section select your desired number format (this is how the data will appear in your output). Format stands for the format to be applied to the expression. It is optional. In VBA Format Date function you have the option to either define your own format or use some of the MS Excel predefined format. Firstdayofweek specifies the first day of the week. If it is not declared, the Format function assumes that Sunday is the first day of the week.

How Do I Format Dates and Numbers With an Out Tag?, A date and time format string is a string of text used to interpret data values containing The function uses the abbreviations associated with the specified locale,  for the dimensions of the newly stored data frame. The file, with 52 rows and 123 columns, is now stored in the income variable. This loads the data with default settings, and R tries to guess what type of data you have, but sometimes it doesn’t do well. So it’s a good idea to specify some things.

Convert string or numeric time values into date format—ArcGIS Pro , Format numbers as dates, currency, or even fractions to cells in a worksheet. Pick the number format Category that you want, and then choose specific from another data source—but Excel doesn't formats those numbers as you expect. Press Ctrl+1 to open the Format Cells dialog. Alternatively, you can right click the selected cells and choose Format Cells… from the context menu. In the Format Cells window, switch to the Number tab, and select Date in the Category list. Under Type, pick a desired date format.

Format numbers - Office Support, Identify form controls that will only accept user input data in a given format. Determine if each of the form controls identified in 1 provides information about the 

  • What did you try?
  • I think you might be missing a "{" at "[27.17.." change it in that way and you would be sending an object with an array of cords that have no properties. It would work but your code would then have to always assume the first value in the object is a lat and the second is a lng.
  • I tried using for loop
  • post the server side code.
  • I need to send Json data as so, you don't want to send JSON data at all,just some randomly formatted data - neither of those blocks of data are valid JSON anyway