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.