Left function, Right Function, or Mid Function to extract values to three decimal places

**bjnockle** · 01-07-2023, 07:23 PM

Looking for formula (Left function, Right Function, or Mid Function) to extract values to three decimal places. See desired outcome below.

Examples:
Format
11.9166666666667 Desired outcome = 11.916

6.96666666666667 Desired outcome = 6.966

Thanks

**protonLeah** · 01-07-2023, 07:45 PM

=int(a1*1000)/1000

**curiouscat408** · 01-07-2023, 07:58 PM

=trunc(a1, 3)

But I'm not sure what you mean by "extract". Extract from what context?!

**HansDouwe** · 01-07-2023, 08:37 PM

Or try

Formula:

Please Login or Register  to view this content.

Or try

Formula:

Please Login or Register  to view this content.

**bjnockle** · 01-07-2023, 08:37 PM

Outstanding solution, protonLeah! Thanks for the rep.

**bjnockle** · 01-07-2023, 08:38 PM

Great solution, HansDouwe

**HansDouwe** · 01-08-2023, 03:22 AM

Thanks for the feedback and rep

.

Left function, Right Function, or Mid Function to extract values to three decimal places

LinkBack

Thread Tools

Rate This Thread

Display

Left function, Right Function, or Mid Function to extract values to three decimal places

Re: Left function, Right Function, or Mid Function to extract values to three decimal plac

Re: Left function, Right Function, or Mid Function to extract values to three decimal plac

Re: Left function, Right Function, or Mid Function to extract values to three decimal plac

Re: Left function, Right Function, or Mid Function to extract values to three decimal plac

Re: Left function, Right Function, or Mid Function to extract values to three decimal plac

Re: Left function, Right Function, or Mid Function to extract values to three decimal plac

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Extract Values using Left, Right, Mid, or Substitute Function

[SOLVED] Extract Values Using Left, Right, or Mid Function

[SOLVED] Extract Values Using Left, Right, or Mid Function

[SOLVED] Extract Values Using Left, Right, or Mid Function

Right function, Left function, Mid function to extract values in column A

[SOLVED] Function is not keeping decimal places

[SOLVED] Function to round up if more than 2 decimal places

Bookmarks

Bookmarks

Posting Permissions