Thread: What does this formula mean [$-F400]h:mm:ssAM/PM
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jacob Skaria Jacob Skaria is offline
external usenet poster
  
Posts: 8,520
Default What does this formula mean [$-F400]h:mm:ssAM/PM
Glenn, this is the locale ID assigned by Microsoft. You may please refer the
below for details

http://office.microsoft.com/en-us/ex...346351033.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
Reply With QuoteReply With Quote