Prev: Sorting
Next: Vlookup and Data Validation Q
From: Glenn on 18 Apr 2010 05:36
What does this formula mean [$-F400]h:mm:ssAM/PM

I am using Excel 2007. I have a spreadsheet I'm trying to understand and
when I custom format on a time value in the spreadsheet the above formula
shows
--
With Appreciation
Glenn
Pinetown, KwaZulu Natal, South Africa
From: Mike H on 18 Apr 2010 05:51
Glenn,

This is what's called setting the Locale or region format for the time.

Select a cell, right click and format and you will see a dropdown on the
right containing various regions. Select one of these and the regional
convention for the date is applied to the cell

$-F400 is UK, it may be others i'm not sure
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Glenn" wrote:

> What does this formula mean [$-F400]h:mm:ssAM/PM
>
> I am using Excel 2007. I have a spreadsheet I'm trying to understand and
> when I custom format on a time value in the spreadsheet the above formula
> shows
> --
> With Appreciation
> Glenn
> Pinetown, KwaZulu Natal, South Africa
From: Jacob Skaria on 18 Apr 2010 05:53
Glenn, this is the locale ID assigned by Microsoft. You may please refer the
below for details

http://office.microsoft.com/en-us/excel/HA010346351033.aspx

--
Jacob (MVP - Excel)


"Glenn" wrote:

> What does this formula mean [$-F400]h:mm:ssAM/PM
>
> I am using Excel 2007. I have a spreadsheet I'm trying to understand and
> when I custom format on a time value in the spreadsheet the above formula
> shows
> --
> With Appreciation
> Glenn
> Pinetown, KwaZulu Natal, South Africa
 | 
Pages: 1
Prev: Sorting
Next: Vlookup and Data Validation Q