european uk currency

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » European / UK Currency

European / UK Currency

resolvedResolved · Low Priority · Version 2003

Francis has attended:
Excel Advanced course

European / UK Currency

How do I create a cell in a worksheet that will only acccept decimal to be entered as 1,111.00 as opposed to european standard 1.000,00

RE: European / UK Currency

Hi Francis

Thank you for your question and welcome to the forum.

I think you could get around this using formatting and conditional formatting.

Firstly I would format the cells to a number with two decimal places.

Secondly try setting data validation on the cells. Go to Data - Validation. Select Decimal, and choose greater than or equal to 0 (assuming all the amounts you are entering into the spreadsheet are positive); then click OK.

Test this out and see if it works for you - if you try entering something into the cells in the european format, the data validation shouldn't allow this to happen.

You can set up error messages and help in the Data Validation when you set up the rule for the validation, to give guidance to people on how to enter figures into the spreadsheet.

Amanda


 

Excel tip:

The dual nature of toolbar buttons

Many toolbar buttons are dual purpose, though the two purposes are often linked in some way. For example, Align Left aligns a cell's contents to the left of the cell. However, hold down Shift and press the Align Left button: Excel aligns the cell contents to the right.
You may respond: So what? Well, you can reduce the number of buttons on your toolbar to make your screen less cluttered and allow more room for, perhaps, some of your own commands. After all, what's the point of an Align Right button when Shift+Align Left does the same thing?

View all Excel hints and tips


Server loaded in 0.08 secs.