Formulas-Functions-Format

New 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

@Ron_FosterCCI 

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

@Riny_van_Eekelen 

Wonderful!  Thank you, so much.