txt file CR

  • Thread starter Thread starter scott
  • Start date Start date
S

scott

when i import a txt file the numbers come through as
445.45CR. there is no way to change this as this is way
the number is stored in thwe accounting program.

how can i create a formula to remove the cr and end up
with a typical accounting number (-445.45)?
 
Hi,

Assuming your numbers are in column A, put this formula in B1 and copy
down:

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

Then, copy > paste special > values

Hope this helps!
 
Back
Top