Custom Cell Formats
I have seen formats like [$-409]h:mm AM/PM appear in the custom formats. The
formatted result is the same with or without the [$-409]. Does anyone know what the significance of [$-409] is? I have seen this since Excel 95 and have never seen a reference to this. Tyro |
Custom Cell Formats
Hi,
Creating international number formats http://office.microsoft.com/en-us/ex...346351033.aspx Mike "Tyro" wrote: I have seen formats like [$-409]h:mm AM/PM appear in the custom formats. The formatted result is the same with or without the [$-409]. Does anyone know what the significance of [$-409] is? I have seen this since Excel 95 and have never seen a reference to this. Tyro |
Custom Cell Formats
Thanks!
Tyro "Mike H" wrote in message ... Hi, Creating international number formats http://office.microsoft.com/en-us/ex...346351033.aspx Mike "Tyro" wrote: I have seen formats like [$-409]h:mm AM/PM appear in the custom formats. The formatted result is the same with or without the [$-409]. Does anyone know what the significance of [$-409] is? I have seen this since Excel 95 and have never seen a reference to this. Tyro |
All times are GMT +1. The time now is 11:20 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com