How to display 0.000 in the result of a XLOOKUP formula

**punksterz626** · 05-25-2023, 12:49 PM

Hello Gurus,

I am using a simple XLOOKUP function to pull data from another worksheet. There are cells with 0.000 listed. The formula works fine pulling all the decimal numbers, but the ones that are in 0.000 are coming in as blanks. I do want it to display as 0.000. I do not want to use the Option formula where all blanks are displayed as 0. I want them as 0.000 and only in that specific column. Is there a way to get it to be displayed as 0.000 rather than as blanks? I do need the column to display as decimal numbers. any help would be greatly appreciated.

**6StringJazzer** · 05-25-2023, 03:03 PM

I do not know any reason that a 0 value would be displayed as a blank, unless you have set the option to show zeroes as blank (there is no option to show blanks as zeroes). Have you checked that? The option is buried so it is unlikely you did it by accident, but it would only take a few seconds to check.

zero.JPG

I think you have some display format issues in your file so we can't just give you a fix for your formula. For that matter you didn't even give us the formula. Can you attach your file for further review?

How to display 0.000 in the result of a XLOOKUP formula

LinkBack

Thread Tools

Rate This Thread

Display

How to display 0.000 in the result of a XLOOKUP formula

Re: How to display 0.000 in the result of a XLOOKUP formula

Thread Information

Users Browsing this Thread

Similar Threads

Xlookup formula to get result from different worksheet

Macro to select next result that an xlookup would return

Xlookup make result blank if contains keyword

XLOOKUP Display next non-zero reading columsn from top down.

[SOLVED] trying to use xlookup to get the result of looking at 2 columns

cell not display result even formula result indicate result is correct

[SOLVED] Need Formula to Display Right Result

Bookmarks

Bookmarks

Posting Permissions