remove trailing zeros from and add decimal point to character string in Excel
Margaret Martin
My values are combinations of numbers and letters. How do I a) remove trailing zeros (up to 2; avoid removing more than 2 trailing zeros) and b) put a decimal point after the 3rd character if there is 4 or more characters ? Some example values:
A61
A6000
A6051
A6050
A610
A611
A6200
A6201
Scott Craner
With what you have provided:
=LEFT(A1,1) & MID(A1,2,LEN(A1))/10^(LEN(A1)-3)
Collected from the Internet
Please contact [email protected] to delete if infringement.
edited at
- Prev: Natural language processing tools for generating OCL
- Next: Remove the day name from date and set it as only 'yyyy-MM-dd HH:mm:ss'
Related
Related Related
- 1
Best way to remove trailing zeros from a Decimal
- 2
Cannot remove trailing zeros from decimal
- 3
Remove leading and trailing zeros from a string
- 4
Remove leading and trailing zeros from a string
- 5
Add trailing zeros to string
- 6
How to remove trailing zeros from decimal number in SQL Server?
- 7
how to remove decimal trailing zeros in matlab
- 8
remove trailing zeros from output
- 9
iOS - remove trailing zeros from float WITHOUT converting to String?
- 10
Using RegEx how do I remove the trailing zeros from a decimal number
- 11
Remove insignificant zeros after the decimal point
- 12
java convert string to int and remove trailing zeros
- 13
Remove decimal point from a decimal string in spark Dataframe
- 14
How to add zeros after decimal point
- 15
How to add zeros after decimal point
- 16
Swift - Remove Trailing Zeros From Double
- 17
Objective C remove trailing zeros after decimal place
- 18
how to remove undesirable trailing zeros when using Cast as Decimal?
- 19
Format string with trailing zeros removed for x decimal places in Swift
- 20
Display trailing zeros in a decimal number in python without returning a string
- 21
Convert from string to double removes trailing zeros
- 22
Convert from string to double removes trailing zeros
- 23
Excel - Remove character from end of string
- 24
Remove trailing zeroes after decimal from double
- 25
Remove trailing '/' from rails string
- 26
php - add comma thousands separator but remove trailing zeros
- 27
php - add comma thousands separator but remove trailing zeros
- 28
I need to remove leading zeros after a decimal point
- 29
Reg Ex: Remove superfluous zeros and decimal point at the end of a number
Comments