Share via

Excel Formula that will keep 0 decimals

Bobby P 221 Reputation points
2021-03-02T22:59:35.773+00:00

Is there an Excel formula that will allow me to keep decimal places? For example, my cell U2 has a value of 4.00. However when I incorporate that into a CONCAT statement, it truncates the .00 and I don't want it to do so because I need to pass those decimals to a SQL Server Database. So I'd prefer 4.00 come over as 4.00.

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,661 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Emi Zhang-MSFT 22,556 Reputation points Microsoft Vendor
    2021-03-03T02:15:39.36+00:00

    Hi @Bobby P ,
    You can try to use TEXT function to keep 2 decimal:

    73563-323.png

    You can also add an auxiliary column to transform cells to TEXT first and then use CONCAT function:
    73409-155.gif

    Hope the information is helpful.

    If the response is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments