Copper Contributor

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.