I am using Excel 365. I have an "Amount" field (Number) with values in A2:
A2
I want to get rid of the leading Zero's so my information looks like this, but nothing I've tried, such as Format Cells, Convert to Number or using =VALUE(A2) works!
I also want to convert the ,(comma) to a . decimal point (without using Find and Replace)
A2
A2
| Amount |
| 0000000000000667,32 |
| 0000000000002667,17 |
I want to get rid of the leading Zero's so my information looks like this, but nothing I've tried, such as Format Cells, Convert to Number or using =VALUE(A2) works!
I also want to convert the ,(comma) to a . decimal point (without using Find and Replace)
A2
| Amount |
| 667.32 |
| 2667.17 |
