| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change date from UK to US for one spreadsheet
Our dates are set to US but I've received a spreadsheet from one of our UK
offices with dates formatted as d/m/y and I need them in US format. How can I do this on the spreadsheet only? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Change date from UK to US for one spreadsheet
Try this small macro:
Sub format_fixer() For Each r In ActiveSheet.UsedRange If r.NumberFormat = "d/m/yyyy" Then r.NumberFormat = "m/d/yyyy" End If Next End Sub -- Gary''s Student - gsnu200771 "Lauren" wrote: Our dates are set to US but I've received a spreadsheet from one of our UK offices with dates formatted as d/m/y and I need them in US format. How can I do this on the spreadsheet only? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Change date from UK to US for one spreadsheet
d/m/y is US format.
It shouldn't matter, Excel should manage it unless they are text. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Lauren" wrote in message ... Our dates are set to US but I've received a spreadsheet from one of our UK offices with dates formatted as d/m/y and I need them in US format. How can I do this on the spreadsheet only? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Change date from UK to US for one spreadsheet
Scrub the comment about d/m/y being US format, but the other part is meant.
-- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Lauren" wrote in message ... Our dates are set to US but I've received a spreadsheet from one of our UK offices with dates formatted as d/m/y and I need them in US format. How can I do this on the spreadsheet only? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I have the date in a spreadsheet change automically. | Excel Discussion (Misc queries) | |||
| How do I have the date in a spreadsheet change automically. | Excel Discussion (Misc queries) | |||
| Change Year Date In A Formula Throughout The Spreadsheet | Excel Discussion (Misc queries) | |||
| Automatic date change when spreadsheet changes | Excel Worksheet Functions | |||
| Automatic date change when spreadsheet changes | Excel Worksheet Functions | |||
Linear Mode
