Regional Date Format

**Chipcom** · 02-19-2007, 03:04 PM

Hi

I need macro that can force date format from any regional date format to hebrew in a specific cell.
for example:
If the user is using US regional date format like 03/14/2001 the macro recognize that the user is using US regional date format and converts it to hebrew date format - 14/03/2001.

Thanks

**VBA Noob** · 02-19-2007, 03:11 PM

Hi,

Record the actions and post back the code

VBA Noob

**Chipcom** · 02-19-2007, 03:22 PM

What do you mean by saying record the action?

**VBA Noob** · 02-19-2007, 03:26 PM

Select a cell

then Go to

Tools > Macro's > record New macro

Then change the formats of the cell to your formats and post the results back here

VBA Noob

Regional Date Format

LinkBack

Thread Tools

Rate This Thread

Display

Regional Date Format

What do you mean

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions