Thread: Reducing the number of digits in a cell
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
starguy starguy is offline
external usenet poster
  
Posts: 1
Default Reducing the number of digits in a cell

use comma instead of semi colon, formula should be like this

=LEFT(A1,LEN(A1)-2)

Borge14 Wrote:
Cheers.

Although for some reason it doesn't seem to be working. Can I email you
the document so you can take a look and see why that may be?


--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=570270

Reply With QuoteReply With Quote