general format

  1. A

    Sorting Dates with General format and time stamp

    Hello All - I have been sent a worksheet with dates from a user in Australia. The date format is: 17/06/2016, so Day, Month, Year. And to be more specific, what I've been sent is: 17/06/2016 18:53, so D, M, Year and a time stamp. There are other dates that I need to merge and sort with these...
    • aiki100
    • Thread
    • date & time format general format merging sorting
    • Replies: 5
    • Forum: Excel Questions
  2. M

    general format issue

    Hi, I have a problem with General format of cells. I have some files that I sent to some colleagues and once I open them all cells in General format were showing like currency format (13.4 in a general format cell, now appeare like 13.40$) I did not find where to configure this general format...
  3. A

    Display commas in general number format

    Is it possible to display commas in the general number format? Here's what I'm trying to do. I have a worksheet in which a user will need to enter numerical values. If they enter 100 I would like it to display 100 if they enter 0.1234 I would like it to display 0.1234 if they enter 1234567 I...
  4. MarkVMcCullagh

    Numeric data in new cells defaults wrongly to Time rather than General in existing XL 2010 Workbooks

    When I go to add content to blank cells in existing workbooks the numeric content automatically defaults to a time format. This does not appear to be the case for new workbooks. Is there any way of clearing blank cells of this problem so that this does not recur and by default the General format...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top