Can I get a value in currency appear in a cell if I only put a number
Hi
I have a workbook and im trying to be able to put a number in and then when enter pushed it displays the value. Lets say N1 I put no1 in and the value in that cell is £50 so once I put 1 in and pushed enter I need it to display £50 .
Can that be done?
I have a workbook and im trying to be able to put a number in and then when enter pushed it displays the value. Lets say N1 I put no1 in and the value in that cell is £50 so once I put 1 in and pushed enter I need it to display £50 .
Can that be done?
Last Comment
Andrew Porter
Yes, right click the cells you want that to occur in, and choose Format. From there, choose currency and the desired currency symbol, then click OK. The cells will now display currency by typing in just the numbers (once you press enter or click away from the cell).
ASKER
Sorry might of confused you there.
What I mean cell M24 is a value lets say £1 and I have to put data into cells N-P 24 and what im trying to do is if I inout a number I.E100 in N24 it would come up 100.00 automatically and so on for all the cells
What I mean cell M24 is a value lets say £1 and I have to put data into cells N-P 24 and what im trying to do is if I inout a number I.E100 in N24 it would come up 100.00 automatically and so on for all the cells
this will occur only if you have correctly formatted the cells N-P 24 beforehand...
By E100 do you mean 100 Euros and you want the values entered converted into GBP.
If you are indeed trying to do a currency conversion then it won't happen by just entering a number in a single cell. You will need to enter a few things:
Source Currency eg Eur
Conversion Currency eg GBP
Conversion Rate eg 1.123
Value to be converted
All of this is doable in Excel fairly simply with a lookup table/matrix.
If you are indeed trying to do a currency conversion then it won't happen by just entering a number in a single cell. You will need to enter a few things:
Source Currency eg Eur
Conversion Currency eg GBP
Conversion Rate eg 1.123
Value to be converted
All of this is doable in Excel fairly simply with a lookup table/matrix.
Or are you talking scaling factor rather than currency?
If you enter 1 in M24 the values in N - P24 are shown as whole numbers.
If you enter 100 in M24, the values in N-P24 are scaled to hundreds
I know you can use Custom format to scale numbers but not sure if you can have it dynamic; might be able to use Conditional Formatting to set some specific Custom formats, eg "1", "1,000" or "1,000,000".
If you enter 1 in M24 the values in N - P24 are shown as whole numbers.
If you enter 100 in M24, the values in N-P24 are scaled to hundreds
I know you can use Custom format to scale numbers but not sure if you can have it dynamic; might be able to use Conditional Formatting to set some specific Custom formats, eg "1", "1,000" or "1,000,000".
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Re-reading, do you just want cells N-P24 to read the same value as M24?
If so, in cells N - P24 just put =$M24
Whatever gets entered in M24, text or number, will be repeated in cells N - P24. If M24 is blank, N - P will show 0; if that is not what is required try this instead:
=IF($M24="","",$M24)
If so, in cells N - P24 just put =$M24
Whatever gets entered in M24, text or number, will be repeated in cells N - P24. If M24 is blank, N - P will show 0; if that is not what is required try this instead:
=IF($M24="","",$M24)
Microsoft Excel
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.
144K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
