ExcelBanter - Format

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Format (https://www.excelbanter.com/excel-discussion-misc-queries/243739-format.html)

cranen

Format

I have item numbers that I enter into my worksheet that look like "327e000".
The item numbers don't always include an "e". The item number I enter in is
used by another cell for a VLOOKUP. So, when Excel formats it to Scientific
Form, the VLOOKUP doesn't work. Can I do a custom format to fix the problem?

Jim Thomlinson

Format

Format the cells as text to keep them as text and avoid the conversion.
--
HTH...

Jim Thomlinson

"cranen" wrote:

I have item numbers that I enter into my worksheet that look like "327e000".
The item numbers don't always include an "e". The item number I enter in is
used by another cell for a VLOOKUP. So, when Excel formats it to Scientific
Form, the VLOOKUP doesn't work. Can I do a custom format to fix the problem?

All times are GMT +1. The time now is 06:07 AM.