Related:

- Wild card functions for IF function in Excel
- Network card - Guide
- Find function on mac - Guide
- Flash drive/card tester - Download - Backup and recovery
- Excel apk for pc - Download - Spreadsheets
- Number to words in excel - Guide

## 3 responses

If the "k" is depicting 1000's, rather change the formatting in those cells to show the value in the formula bar as e.g. 15, but under cell formatting select Number, Custom and enter ####"k". This way the value of the cell is still numeric and thus calculable, but when printing or displaying it, it will show it as e.g. 15k.

venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811

Jul 26, 2009 at 05:12 AM

Jul 26, 2009 at 05:12 AM

suppose A1 down is

15k

14k

13k

12k

11k

10k

in B1 copy paste this formula

=LEFT(A1,LEN(A1)-1)+0

copy B1 down

add column B

I could have had formula

=left(A1,2)+0

but this will not work if your numbers are more than 2 digits, e.g. 122k

15k

14k

13k

12k

11k

10k

in B1 copy paste this formula

=LEFT(A1,LEN(A1)-1)+0

copy B1 down

add column B

I could have had formula

=left(A1,2)+0

but this will not work if your numbers are more than 2 digits, e.g. 122k