1. Forum
  2. Usenet
  3. MICROSOFT.PUBLIC.EXCEL.MI

  • cell formatted as date won't change

    From Salim Bashar@21:1/5 to NEHicks on Sun Mar 14 04:52:53 2021
    Basically, the country locale you are in might be the one.

    Go to File -> SpreadSheet Settings. Select the correct Locale.

    Eg, US is mm/dd/yyyy whereas UK is dd/mm/yyyy

    Then you try again to change the format.

    Hope this helps.

    Salim Bashar
    Singapore.

    On Wednesday, July 22, 2009 at 12:45:02 AM UTC+8, NEHicks wrote:
    I have a column of dates (Jul 2,2009) that I want to format as 7/2/09. I can change the formatting to anything I want and the cells never change. What's wrong?

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From =?UTF-8?B?w5ZtZXIgWcSxbGTEsXo=?=@21:1/5 to All on Tue Mar 29 04:31:26 2022
    14 Mart 2021 Pazar tarihinde saat 14:52:56 UTC+3 itibarıyla Salim Bashar şunları yazdı:
    Basically, the country locale you are in might be the one.

    Go to File -> SpreadSheet Settings. Select the correct Locale.

    Eg, US is mm/dd/yyyy whereas UK is dd/mm/yyyy

    Then you try again to change the format.

    Hope this helps.

    Salim Bashar
    Singapore.
    On Wednesday, July 22, 2009 at 12:45:02 AM UTC+8, NEHicks wrote:
    I have a column of dates (Jul 2,2009) that I want to format as 7/2/09. I can
    change the formatting to anything I want and the cells never change. What's
    wrong?

    dilerseniz https://beyazesyaalanyer.com olarak eşyalarınızı aldığımızı hatırlatmak isteriz

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From David Shaw@21:1/5 to Salim Bashar on Wed Jul 27 05:50:09 2022
    On Sunday, 14 March 2021 at 11:52:56 UTC, Salim Bashar wrote:
    Basically, the country locale you are in might be the one.

    Go to File -> SpreadSheet Settings. Select the correct Locale.

    Eg, US is mm/dd/yyyy whereas UK is dd/mm/yyyy

    Then you try again to change the format.

    Hope this helps.

    Salim Bashar
    Singapore.
    On Wednesday, July 22, 2009 at 12:45:02 AM UTC+8, NEHicks wrote:
    I have a column of dates (Jul 2,2009) that I want to format as 7/2/09. I can
    change the formatting to anything I want and the cells never change. What's wrong?
    You are a genius. This works!

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Nur Khalieda Azlan@21:1/5 to David Shaw on Tue Mar 21 01:53:01 2023
    On Wednesday, July 27, 2022 at 8:50:11 PM UTC+8, David Shaw wrote:
    On Sunday, 14 March 2021 at 11:52:56 UTC, Salim Bashar wrote:
    Basically, the country locale you are in might be the one.

    Go to File -> SpreadSheet Settings. Select the correct Locale.

    Eg, US is mm/dd/yyyy whereas UK is dd/mm/yyyy

    Then you try again to change the format.

    Hope this helps.

    Salim Bashar
    Singapore.
    On Wednesday, July 22, 2009 at 12:45:02 AM UTC+8, NEHicks wrote:
    I have a column of dates (Jul 2,2009) that I want to format as 7/2/09. I can
    change the formatting to anything I want and the cells never change. What's
    wrong?
    You are a genius. This works!
    THIS WORKS< THANKS YALL

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)