Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-26-2013, 04:59 AM
tinfanide tinfanide is offline What is [$-804]? Windows 7 64bit What is [$-804]? Office 2010 32bit
Expert
What is [$-804]?
 
Join Date: Aug 2011
Posts: 312
tinfanide is on a distinguished road
Default What is [$-804]?


Code:
Format(Date, "mm/dd/yyyy[$-804](aaa)")
I want to ask what we call "[$-804]".
Thank you.
Reply With Quote
  #2  
Old 10-28-2013, 07:28 PM
BobBridges's Avatar
BobBridges BobBridges is offline What is [$-804]? Windows 7 64bit What is [$-804]? Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

I mentioned that myself, recently; I didn't exactly ask, just mentioned in passing that I was seeing it, and someone chimed in—it was fairly recently, so you may be able to find it by searching through posts in the last month or two—that it has something to do with the way Excel identifies, um...a particular regional setting? Yeah, maybe that was it. I don't remember. But someone around here seemed to.
Reply With Quote
  #3  
Old 10-28-2013, 07:40 PM
tinfanide tinfanide is offline What is [$-804]? Windows 7 64bit What is [$-804]? Office 2010 32bit
Expert
What is [$-804]?
 
Join Date: Aug 2011
Posts: 312
tinfanide is on a distinguished road
Default

I have searched the Internet for the answer and I got it. It is something like locale codes.

Yet, my original thought was I could not use it in the Word VBA. It works in the Excel VBA, though. So I wonder how I can display another regional date format in Word using "Format(Expression,"")".
Reply With Quote
Reply

Thread Tools
Display Modes


Other Forums: Access Forums

All times are GMT -7. The time now is 06:04 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft