View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
RChicken RChicken is offline
external usenet poster
 
Posts: 1
Default Too Many Numbers After The Decimal


I'm trying to update the prices of several thousand products, so i'm
useing the vlookup function, but the prices that are getting displayed
have 5 or 6 numbers after the decimal. how can i condense this down
into only 2 without using the format option.


--
RChicken
------------------------------------------------------------------------
RChicken's Profile: http://www.excelforum.com/member.php...o&userid=33601
View this thread: http://www.excelforum.com/showthread...hreadid=558478