Ramco Ramco

Ramco Ramco

  • 442
  • 3.4k
  • 515.5k

Dollar Sign not showing

Jun 29 2023 11:52 AM

Hi

   I have below data . When i use Vlookup it shows only numerical value . I want Dollar should also be shown. It shows only 7163.

=VLOOKUP(28,A2:F214,4,FALSE)

27	Mango	Fruit	$7,388	18/02/2016	France
28	Beans	Vegetables	$7,163	18/02/2016	United States

Thanks


Answers (3)