Forum Discussion
Formulas-Functions-Format
I simply want to enter a general number, with no decimal point, into a cell and have that number converted to a currency number with a decimal point placed before the last two digits and shown in the same cell (I know a formula would be =(#)*.01
Example: Enter 2515
Number converted to $ 25.15
2 Replies
Under File, Options, Advanced, Editing Options you can enable a setting to add a decimal point at "2 places". Format the cell as currency with the $ sign and you can enter 2515 and return $25.15
Wonderful! Thank you, so much.
