Share via

Excel not using regional settings

Anonymous
2010-02-16T14:26:51+00:00

Hi - I have set my regional settings to use brackets (23) for negative numbers. I've set both the number and currency formats to use brackets for negative number. WHen starting Excel, using a new blank workbook, negative numbers entered into a cell do NOT show with brackets? My language is set to English (Canada) and I've adjusted the formats to use brackets for negative numbers and I've copied to reservered accounts.

 I also want the date to default to the short date format I've set for the language but it too is not working. Excel will not use the default format I've set? How do you fix?

Thanks

Dweezil38

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2010-02-17T05:13:01+00:00

After formatting excel file did you save the file in XLSTART?

You have to save the formatted excel file in XLSTART folder so that you can open a new document with the customized formats.

Location of XLSTART folder  C:\Users[username]\AppData\Roaming\Microsoft\Excel\XLSTART

Check if this helps.

Praveen Bhat, Microsoft Answers Support Engineer.

• We appreciate your participation in MS Forums, Help us understand your needs better. To share your valuable Feedback please Click here.

Was this answer helpful?

0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest