EXCEL SPREADSHEET

Copper Contributor

HI THERE

     I AM NEW TO EXCEL AND TRYING TO FILL A SPREADSHEET USING DOLLAR AMOUNTS.  HOW DO I GET ALL OF MY ENTRIES TO ENTER WITH THE DECIMAL POINT.  EXAMPLE   45.00  AND NOT 45 AS IT ENTERS WHEN I INPUT IT ?  

 

 

1 Reply

 If I may recommend you add a file (without sensitive data) and explain your plans on the basis of this file, so you can come up with a proposed solution much faster and more precisely.

Here is some information about it: Welcome to your Excel discussion space!

 

Nonetheless, here are some links on the subject of currency.

Format numbers as currency in Excel for the web

Format numbers as currency

Depending on the Excel version, you will find the relevant information / lin.

 

Hope I was able to help you with this info.

 

NikolinoDE

I know I don't know anything (Socrates)

 

Was the answer useful? Mark them as helpful!

This will help all forum participants.

 

@trescak14gmailcom